SFTDEL: Deleting the Shift Code From DBCS Data

How to:

If your configuration uses a DBCS code page, you can use the SFTDEL function to delete the shift code from DBCS data.


Top of page

x
Syntax: How to Delete the Shift Code From DBCS Data
SFTDEL(source_string, length, output)

where:

source_string

Alphanumeric

Is the string from which the shift code will be deleted enclosed in single quotation marks (') or the field containing the string.

length

Integer

Is the length of the source string in bytes or a field that contains the length. The string can have a mixture of DBCS and SBCS characters. Therefore, the number of bytes represents the maximum number of characters possible in the source string.

output

Alphanumeric

Is the field to which the result is returned or the format of the output value enclosed in single quotation marks (').



Example: Deleting the Shift Code From a String

In the following, SFTDEL deleted the shift code from the COUNTRY field (up to 10 bytes long):

COUNTRY_DEL/A10 = SFTDEL(COUNTRY, 10, 'A10');

The output in ASCII environments is shown in the following image:

The output in EBCDIC environments is shown in the following image:


WebFOCUS