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)


Did this page help you?