Hello I have a string field that I'm trying to remove the spaces characters but I had used right-trim, left trim to see if it would work but the result stays the same.
The output of the field is:
MPC P
G
KKK P
I tried using Delete Spaces function and it removes the space but leaves 1 space. I would like to use a function to remove all the spaces.
Based on that output I'm trying to remove the spaces for the first and third record but the result remains the same.
Any idea?
Min
