Challenge #4: Date Parsing

[Derangedvisions]

wow i've been gone for too long...back at it the hard way...messing with Dates 😕 

I couldn't for the life of me figure out how to replace the one digit date so i might have fudged that one slightly 😛

Spoiler

[ranjith26]

Struggled a bit frankly! But finally got it!!!

[Trumble_dup_334]

Loved this challenge although I did have to refer to the solution a little to get my head around the date manipulation bit to make it play nicely with Alteryx. There has to be a better way for Alteryx to handle dates natively. First intro to RegEx and have to say it was great. Steep learning curve but easy to understand once you have a go.

Spoiler

Got the expression down to 2 outputs with this:

(\d+-[A-Za-z]{3,4}-\d+)|([A-Z][a-z]{2,3}\s\d+,?\s\d+)

No point going for a single column output as the date manipulation later on in the flow would be a real pain if so.

[sonyakasenkramer]

Spoiler

[mccartycp]

Spoiler

I used a bit to many parses and a bit too many formulas...Need to work on parsing to capture all scenarios!

[meeravijayan2011]

Spoiler

[AV8]

Need to work more on Regex.

Spoiler

Spoiler: