regexp_count_array

Usage Details

Input
table

col

col
random 123 text 456 test

LQL Command

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

Output

col	countarray

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