Challenge #4: Date Parsing

[MarqueeCrew]

I thought that I was pretty clever :D

mark

[SeanAdams]

done - but clearly did this the long way round

Spoiler

- split out each different format of date using Reg-Ex; and a custom date converter
- commented each section with the date format for easy maintenance

Thank you to @markp201 for the regex code - good to see the patterns like this - and to @MarqueeCrew for the super-scary-looking-inline-formula version (very impressive!)

[MarqueeCrew]

@SeanAdams,

i would be be happy to walk you through my scary code. It really is just a big OR statement to search for the different patterns. 

Let me me know if you're interested. 

[SeanAdams]

Thank you @MarqueeCrew - walking through it, the OR logic makes sense - the part that I wouldn't have come to on my own steam is the way that it seems that you've replaced the outer part of the string, rather than the pattern-matched date (it seems kinda like saying "this is how you recognize an apple seed - now throw away the rest") :-).    it's not an intuitive pattern, but makes sense once you see it.

It would be good to make contact, even if just to extend the network of like-minded folk - not sure how to PM you on the Alteryx infra, but I've sent you a ping on LinkedIn and Google+

Many thanks for your kind offer @MarqueeCrew

Sean

[NicoleJohnson]

Solution posted. :)

Spoiler

[Laurap1228]

This one was tough! I definitely used the On Demand Regex video to help me solve it.

Spoiler

[DE0413]

Spoiler

I used a Regex Parse to Parse the 3 date formats into 3 new fields. Next, I used a formula tool to create a field with a consistent format of the dates, finally I used a select tool to deselect extra fields and rename the final date formatted field.

 I don't know why my attachments are opening in html and not Alteryx.

[LordNeilLord]

The datetimeparse tool makes life so much easier...

Spoiler

[irisTZ]

this one is hard...