Use the @STREXT function to extract a portion of a string.

Syntax

result = @STREXT (string, begin_position, end_position)

string

The string from which to extract. The string can be either the name of a column or a literal string. Enclose literals within quotes.

begin_position

The character position at which to begin extracting.

end_position

The character position at which to end extracting. The end position is included in the extraction.

Example

The following example uses three @STREXT functions to extract a phone number into three different columns.

AREA_CODE = @STREXT (PHONE, 1, 3),
PREFIX    = @STREXT (PHONE, 4, 6),
PHONE_NO  = @STREXT (PHONE, 7, 10)