Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
Using two RegEx statements to find the numbers and possible months, before using a Find/Replace to clean the months (using a simple text input of JAN, FEB, MAR, etc), a formula to get the correct 4 digit year and then joining it all together....
Only attaching for historical sake, had to copy my solution. New to alteryx and only going through these to learn! Hopefully around challenge 100 I'll have more of my own answers 😂