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)
where:
Integer
Is the number of characters in source_string and output.
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 |