STRIP
Returns a string stripped of leading, trailing pad characters, and/or any specified character.
Syntax
STRIP(string,[how,character])
Argument
Argument | Description | Default | |
---|---|---|---|
string | The string from which Enrichment is to strip character. | None | |
[how] | One of the following: | B | |
A | Strip all occurrences of character from string. | ||
L | Strip leading occurrences of character from string. | ||
T | Strip trailing occurrences of character from string. | ||
B | Strip both leading and trailing occurrences of character from string. | ||
[character] | The character to strip from the string. | ''(blank) |
Results
Result | Description |
---|---|
Return | string with character stripped as appropriate. |
%%RC | Always set to 0. |
%%RM | A null string (''). |
%%RV | Always set to 0. |
Examples
Function Call | Return |
---|---|
STRIP('____Total___',L,'_') | 'Total___' |
STRIP('____Total___',B,'_') | 'Total' |
STRIP('____Total___X',B,'_') | 'Total___X' |