Regex: If expression match then "y"

[BautistaC888]

Hello,

I need to fill a check column  this way:
Ifthe decription match this expression
11 digits - date - 4 digits - 8 digits thes "y".

For example:

I wonder if its possible with a REGEX.

Thank you.

[mceleavey]

Hi @BautistaC888 ,

I've built this as a Regexmatch function in a formula tool:

if REGEX_Match([Description], "\d{11}\s[-]\s\d\d[/]\d\d[/]\d{4}\s[-]\s\d{4}[-]\d{8}")=-1 then "Y" else "N" endif

I hope this helps,

M.