REGEX_MATCH_POSITION
Last updated: 9/22/2026Matches the regular expression on the input string, and returns the index of the first match.
Syntax
REGEX_MATCH_POSITION(pattern, value, startPosition)
Arguments
| Name | Type | Description | Default Value |
|---|---|---|---|
| pattern | string | Pattern to search for | |
| value | string | ||
| startPosition | numeric |
Returns
Returns a bigint value.
Examples
| pattern | value | startPosition | Output |
|---|---|---|---|
| ',' | '1,2,3' | 0 | 1 |
| '2,\d' | '1,2,3' | 2 | 2 |
| '2,\d' | '1,2,3' | 3 | null |
| ',' | '1,2,3' | -1 | null |
| ',' | '1,2,3' | -2 | 3 |