Regex Functions
5 functions for pattern extraction, replacement, and matching. The source column is always the implicit first input.
| Function | Syntax | Parameters | Notes |
|---|---|---|---|
regex_extract | regex_extract(column, pattern, caseInsensitive, group) | pattern — required regex. caseInsensitive — boolean. group default 1. | Also accepts groupIndex as a legacy alias for group. |
replace_regex | replace_regex(column, pattern, replacement) | pattern — required regex. replacement — replacement string. | |
matches_regex | matches_regex(column, pattern, caseInsensitive) | pattern — required regex. caseInsensitive — boolean. | Returns boolean. |
regex_position | regex_position(column, pattern, caseInsensitive, startPos) | pattern — required regex. caseInsensitive — boolean. startPos default 1. | Returns 1-indexed match position. |
regex_count | regex_count(column, pattern, caseInsensitive) | pattern — required regex. caseInsensitive — boolean. | Counts non-overlapping matches. |