How to: |
The TRIM_ function removes all occurrences of a single character from either the beginning or end of a string, or both.
Note:
TRIM_(where, pattern, string)
where:
Keyword
Defines where to trim the source string. Valid values are:
Alphanumeric
Is a single character, enclosed in single quotation marks ('), whose occurrences are to be removed from string. For example, the character can be a single blank (‘ ‘).
Alphanumeric
Is the string to be trimmed.
The data type of the returned string is AnV.
TRIM_ removes leading occurrences of the character ‘B’ from DIRECTOR.
TRIM_(LEADING, 'B', DIRECTOR)
For BROOKS R., the result is ROOKS R.
WebFOCUS | |
Feedback |