Return to FileMaker.com
How to remove X characters from beginning or end of a string
Let's say I have multiple records in which there is a particular field containing data that looks like:
How can I remove the 5 rightmost characters so I'm left with:
I don't think I can use Left since there are different numbers of characters leading up to the unwanted 5 characters. The characters I don't want are: Right( field_name, 5 ). How do I erase them?
Left ( YourField ; Length ( yourField ) - 5 )
will return all but the last 5 characters.
Retrieving data ...