AnsweredAssumed Answered

Trim function- not deleting leading space

Question asked by AreliLopez on Sep 2, 2011
Latest reply on Sep 2, 2011 by philmodjunk


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")