Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi everyone,
why does the following formula throw a 0 for an array value like test123456?
arrayLen(match(column,".*\d{6}([\?#].*)?$"))
The regex works fine as far as I can tell.
Thanks!
Hi,
the the backslash of the `\d` character class must be escaped. So you need ".*\\d{6}([\\?#].*)?$"
Hi,
the the backslash of the `\d` character class must be escaped. So you need ".*\\d{6}([\\?#].*)?$"
Makes sense, thank you!