How to: |
The TRIM function removes leading and/or trailing occurrences of a pattern within a character string.
TRIM(trim_where, source_string, length, pattern, sublength, output)
where:
Alphanumeric
Is one of the following, which indicates where to remove the pattern:
'L' removes leading occurrences.
'T' removes trailing occurrences.
'B' removes both leading and trailing occurrences.
Alphanumeric
Is the string to trim .
Integer
Is the number of characters in the source string.
Alphanumeric
Is the character string pattern to remove.
Integer
Is the number of characters in the pattern.
Alphanumeric
TRIM removes leading occurrences of the characters BR from DIRECTOR and stores the result in a column with the format A17:
TRIM('L', DIRECTOR, 17, 'BR', 2, 'A17')
For BROOKS R., the result is OOKS R.
For ABRAHAMS J., the result is ABRAHAMS J.
iWay Software |