Reference Guide
>
TDV Support for SQL Functions
>
Character Functions
>
REGEXP_EXTRACT
REGEXP_EXTRACT
A string function used in search operations for sophisticated pattern matching including repetition and alternation.
Syntax
REGEXP_EXTRACT(string, expr_to_match, (optional) which part of matching string to be returned)