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


      ELSE "0"



      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.