This is a strange one...I have a Trim Function on all my fields of data that I'm stripping off a report, but one field doesn't seem to be removing my spaces?
Any idea why...please see attached screen shot.
Is there a possibility of that being any other kind of invisible character like a carriage return, line feed, or a TAB. I guess Trim strips off a TAB too...need to check, but could be other invisible characters.
What happens when you click the button with two dots? Does the caret (or the cursor) go to the next line after 004 when you move it using the arrow keys?
Check out for any kind of invisible characters using a free text editor like Notepad++.
I'm using UltraEdit and it appears the reason why is because there are NULLS in the space, but UltraEdit displays them as spaces, so until I looked at the HEX, it appeared they were spaces, but in reality they were NULLS.