Regex query

[StephenMoss]

Hi everyone. 

I have a quick question regarding an old Alteryx challenge I found on youtube yesterday which despite relentless googling I can't find the answer to. 

The challenge asks to parse a date (which is in US format) such as 1/11/2011, into its component parts of month, day and year using Regex. 

Any help on how to solve this problem would be much appreciated, as I often work with data sets separated by special characters.

Thanks in advance!   

[afv2688 · Accepted solution]

Hello @StephenMoss ,

The regex formula that you could use to parse the data would be

(\d+)/(\d+)/(\d+)

If you need any furher assistance with this let me know 🙂

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Kind regards

[StephenMoss]

Hi 

Great, thanks so much for your help, this worked exactly as I wanted, much appreciated!