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