Challenge #4: Date Parsing

[TerrenceM]

スポイラ

 

[lynnesonneyrsm]

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

[asjohnson]

Likely not the simplest

スポイラ

[swethamadesh]

Hi,

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

PFA.

[DaisukeTsuchiya]

スポイラ

[jgvillalta]

My solution

[Ed2000]

スポイラ

[CE_5085781]

My take on the solution...

スポイラ

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.

スポイラ

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