regexp_extract_array

Extract all matches for a given regex pattern from a string.

Usage Details

Input
table

col
random 123 text 456 test

select *, regexp_extract_array(col, '[a-z]+') as matches  from table

Output

col	matches
random 123 text 456 test	WrappedArray(random, text, test)

Updated about 1 year ago