Pan Number Validation

[Vapour02]

Hello all I'm trying to validate the Pan Number in Alteryx but unable to find how to do that. Pan number is of 10 characters the format is first 5 Alphabets 4 numbers and then 1 alphabet. Now I want to validate if all the data is in correct format or not. Please help.

[LisaL]

@Vapour02 

This is easiest to do using Regex, however the exact string used is not something I have handy.  It will be something like '\d{5}[a-zA-Z]{4}\d{1}' to be used in conjunction with Regex_match function.  Review the Help section on that function together with your favorite guide to regex (I like https://regex101.com/)  I wish you the best of luck!

[Vapour02]

Thank you so much. I explored and tried a bit different one - ^[A-Z] {5}[0-9]{4}[A-Z]{1}$ and it worked.