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

colcountarray
random 123 text 456 testWrappedArray(2, 3)

© Devo Technology Inc. All Rights Reserved.