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.


Top of page

x
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



Example: Removing a Double-Byte Character From a String

In the following:


iWay Software