Challenge #4: Date Parsing

[TerrenceM]

Spoiler

 

[lynnesonneyrsm]

wouldn't be as repeatable as others, but I got to the right spot!

[asjohnson]

Likely not the simplest

Spoiler

[swethamadesh]

Hi,

My Regex skills are basic and here is my way of getting desired output

PFA.

[DaisukeTsuchiya]

Spoiler

[jgvillalta]

My solution

[Ed2000]

Spoiler

[CE_5085781]

My take on the solution...

Spoiler

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....

[barrymoe]

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 😂

[Bobbyt23]

Argh Regex, my old nemesis.

Spoiler

Still not one of my strong points so had to split it out to make sure I was getting it right.