regexp_extract_array

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

Usage details

Input
table

col

col
random 123 text 456 test

LQL Command

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

Output

col	matches

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