REGEX_SEARCH
Use the REGEX_SEARCH function to find a matching regular expression pattern in a text value. It returns the position of the first character of the match in the second text value.
Use
REGEX_SEARCH( pattern , within_text [, start_num] )
Finds a matching regular expression pattern within a text value and returns the relative position of that match.
| Parameter | Required | Description |
|---|---|---|
| pattern | Yes | the regular expression to match |
| within_text | Yes | the text to search |
| start_num | No | specifies the character at which to start the match (starting from 1) |
| Returns | Number |
Example
This section isn’t ready just yet—we’re working on it! Please check back soon, and if you need help right away, feel free to ask in our Community Forum.
ON THIS PAGE