Regrx match if the 3rd character of the string is Alpha

[Sean1963]

The string function I am using is: REGEX_Match([Serial Number], "^.{2}[a-zA-Z]") 

It returns False for numbers like 17D6Q856 where I am pretty sure it should return True.  I am willing to accept that my regular expression expertise might be at fault.

Thank you very much for any assistance.

[estherb47 · Accepted solution]

Hi @Sean1963 

Regex_Match has to match to the entire string. The statement you wrote is only for the first 3 characters. Try adding a ".+" to the end to capture the rest of the string as well.

Let me know if that helps.

Cheers!

Esther

[Sean1963]

REGEX_Match([Serial Number], "^.{2}[a-zA-Z].+") worked like a champ!

Thank you very much