How to: |
The STRIP function removes all occurrences of a specific character from a string. The resulting character string has the same length as the original string but is padded on the right with spaces.
STRIP(length, source_string, char, output_format)
where:
Integer
Is the number of characters in the source_string and output_format.
Alphanumeric
Is the string from which the character will be removed.
Alphanumeric
Is the character to be removed from the string. If more than one character is provided, the left-most character will be used as the strip character.
Note: To remove single quotation marks, use two consecutive quotation marks. You must then enclose this character combination in single quotation marks.
Alphanumeric
STRIP removes all occurrences of a period (.) from DIRECTOR and stores the result in a field with the format A17:
STRIP(17, DIRECTOR, '.', 'A17')
For ZEMECKIS R., the result is ZEMECKIS R.
For BROOKS J.L., the result is BROOKS JL.
iWay Software |