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

colmatches
random 123 text 456 testWrappedArray(random, text, test)

© 2017-2021 LogicHub®. All Rights Reserved.