3 Replies Latest reply on Oct 13, 2016 10:47 PM by Raju Kumar

    Doing a TRIM on a field - Get a #Error

    Dan Burrell

      Some basically I am doing the following on a field.

       

      I have a field that ends in "My favourite number is $2000.00" for example and I am trying to capture that value on the end

       

      if not isnull([Text]) then

      trim(right(trim([Text]),9))

      ELSE "0"

      end

       

      However no matter which way i do it, I get a #Error in the field

       

      What am I missing here?

       

      I am certain I have done things like this before with text fields.