Description
TrimRight removes all spaces to the right of a string or data field which is stored left-justified in a database.
Action
TrimRight removes all spaces to the right of a string or data field which is stored left-justified in a database.
Typical uses
Use this function any time there are trailing blanks in a text object that may interfere with an alignment of text strings, a character count, or with a calculation (if the string is eventually converted to a Number).
Use whenever you combine (concatenate) justified text strings and want to have the proper spacing between strings.
Examples
TrimRight("Al/4520/B12 ")
Returns "A1/4520/B12".
TrimRight({file.REFERENCE})
Returns "Bal Fwd." where the text string "Bal Fwd. " is left-justified in the field.