regexp_count_array

Get count of pattern matches for a list of patterns.

Usage Details

Input
table

col
random 123 text 456 test

select *, regexp_count_array(col, Array('\\d+', '[a-z]+')) as countarray from table

Output

col	countarray
random 123 text 456 test	WrappedArray(2, 3)

Updated 12 months ago