Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Issue with regex + arrayLen + match (min. 6 digits in string)
Added on January 24, 2022 11:05PM
Likes: 0
Replies: 2
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!
Best Answer
-
Hi,
the the backslash of the `\d` character class must be escaped. So you need ".*\\d{6}([\\?#].*)?$"
Answers
-
Makes sense, thank you!