The DSTRIP function removes all occurrences of a specific single-byte or double-byte character from a string. The resulting character string has the same length as the original string but is padded on the right with spaces.
DSTRIP(length, source_string, char, output)
Is the number of characters in source_string and outfield.
Is the string from which the character will be removed.
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.
Is the name of the field that contains the result, or the format of the output value enclosed in single quotation marks (').
In the following: