REGEX_EXTRACT function
The regex_extract function takes an input string and a regular expression (regex) pattern and extracts all the substrings that match the pattern. It returns a list of these matching substrings. This function is useful for parsing text and extracting specific data based on patterns, such as extracting email addresses, phone numbers, dates, or any other patterns from a given text.
Syntax
regex_extract(<val>, <pattern>)
| Parameter | Type | Description |
|---|---|---|
| val | string | |
| pattern | string |