I have an auto calc field that always end with a space, then a |
John Doe |
How can I remove the space and the character from this field?
a couple of different ways but you can do a left() on it for the length of the string minus 2
Thank you. I used this: Left ( MyTextField; -2 ) and it removed all the text from the field. What did I do wrong?
as wimdecorte said there is a bunch of ways to do this.
The way he proposed meets your description of the goal perfectly.
Substitute() with multiple criteriancould remove all spaces and pipes.
Trim() would just remove leading and trailing spaces.
Best to read up on and experiment with all the text functions.
you didnt include the length of the string..
Left ( string; Length ( string) - 2 ) is what he described
Perfect. Thank you. That's exactly what I need.
Retrieving data ...