DSTRIP: Removing a Single-Byte or Double-Byte Character From a String

How to:

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.

Syntax: How to Remove a Single-Byte or Double-Byte Character From a String

DSTRIP(length, source_string, char, output)

where:

length

Double

Is the number of characters in source_string and outfield.

source_string

Alphanumeric

Is the string from which the character will be removed.

char

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.

output

Alphanumeric

Is the name of the field that contains the result, or the format of the output value enclosed in single quotation marks (').

Example: Removing a Double-Byte Character From a String

In the following: