REGEXP_EXTRACT_ALL
Extracts all substrings that match a regular expression pattern.
Analyze Syntax
func.regexp_extract_all(<str>, <pattern>)
Analyze Examples
func.regexp_extract_all('a1b2c3', '\\d+')
┌───────────────┐
│ ['1','2','3'] │
└───────────────┘
SQL Syntax
REGEXP_EXTRACT_ALL(<str>, <pattern>)
SQL Examples
SELECT REGEXP_EXTRACT_ALL('a1b2c3', '\\d+');
┌───────────────┐
│ ["1","2","3"] │
└───────────────┘