In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.

Pan Number Validation

Vapour02
8 - Asteroid

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.

2 REPLIES 2
LisaL
Alteryx Alumni (Retired)

@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!

Lisa LePome
Principal Support Engineer -- Knowledge Management Coach
Alteryx, Inc.
Vapour02
8 - Asteroid

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