Issue with regex + arrayLen + match (min. 6 digits in string)
ebbingcasa
Registered Posts: 24 ✭✭✭✭✭
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!
Tagged:
Best Answer
-
Hi,
the the backslash of the `\d` character class must be escaped. So you need ".*\\d{6}([\\?#].*)?$"
Answers
-
Makes sense, thank you!