Issue with regex + arrayLen + match (min. 6 digits in string)

[ebbingcasa]

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!

[fchataigner2 · Accepted solution]

Hi,

the the backslash of the `\d` character class must be escaped. So you need ".*\\d{6}([\\?#].*)?$"

[ebbingcasa]

Makes sense, thank you!