2022-10-26 10:30 AM
Hello,
I use this meta key : param_dst (type : string[]) and I want to count the number of occurences of '^' character in param_dst string(s) in order to compare the number obtained with another number.
- What I did :
SELECT *
FROM Event (
asStringArray(param_dst).anyOf(i => i.contains('^'))
)
and it returns a boolean indicating whether or not there is a single '^'.
So, how can I count the number of occurences of a character ?
Thanks,