5 Replies Latest reply on Sep 2, 2011 11:29 AM by philmodjunk

    Trim function- not deleting leading space



      Trim function- not deleting leading space


      I am having a problem using the trim function. I have a text field where my data has an extra leading space that needs to be removed. it only contains one word. I want to remove all leading and trailing spaces so I can use the exact function in a calculation to compare to another field. I have use this function before for the same purpose and it has worked, I don't understand why is not working now?

      my calculation field, where I am using the trim function looks like this:

      If (Exact(Trim(Field);Trim(Field2)); "match", "not match")