Reference Guide
>
TDV Support for SQL Functions
>
Character Functions
>
REGEXP_SUBSTR
REGEXP_SUBSTR
will allow you to extract a substring from a string using regular expression pattern matching.
Syntax
REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )