REGEX_EXTRACT_ALL

All functions > STRING > REGEX_EXTRACT_ALL

Returns an array of all substrings matching a regular expression pattern.

Signatures

Returns: Array of all matching substrings

REGEX_EXTRACT_ALL(string: VARCHAR, pattern: VARCHAR, [group_number: BIGINT]) → ARRAYVARCHAR

Notes

• Returns all non-overlapping matches in order
• Group 0 (default) returns the entire match for each occurrence
• Group 1+ returns the corresponding capture group for each occurrence
• Returns an empty array if no matches are found

Examples

SELECT
    f1 := REGEX_EXTRACT_ALL('abc123def456', '[0-9]+'),  -- Extract all digit groups
    f2 := REGEX_EXTRACT_ALL('cat bat hat', '[a-z]at'),  -- Extract all matches
    f3 := REGEX_EXTRACT_ALL('a1b2c3', '([a-z])([0-9])', 1),  -- Extract first capture group
    f4 := REGEX_EXTRACT_ALL('no match', '[0-9]+')  -- No matches returns empty array
;