2.31 @STREXT
Use the @STREXT
function to extract a portion of a string.
For this function, Oracle GoldenGate supports the use of an escape sequence to represent characters in a string column in Unicode or in the native character encoding of the Microsoft Windows, UNIX, and Linux operating systems. The target column must be a SQL Unicode data type if any argument is supplied as Unicode.
This function does not support NCHAR
or NVARCHAR
data types.
Syntax
@STREXT (string, begin_position, end_position)
-
string
-
The string from which to extract. The string can be either the name of a character column or a literal string. Enclose literals within single quote marks.
-
begin_position
- The character position at which to begin extraction.
-
end_position
-
The character position at which to end extraction. 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)
Parent topic: Column Conversion Functions