4.24 STREXT
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)