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' |