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)


Did this page help you?