Challenge #2: Preparing Delimited Data

[jacob_kahn]

I found this awesome tool called "Date-Parse" on the Community Page.

I think that the provided solution by Alteryx used "too" many formulas for Alteryx!

[CsHind80]

Pretty simple one once you get it. However, I admit that I had to look up the exact format for the date/time tool.

The unsung hero of this challenge was the formula tool. 

Looking forward to the next one!

[TonyA]

Nothing all that different from others. I did add an Auto Field tool to get the Poem column down to 53 characters as in the example output. Also I played with formulas a bit using a date format string that included the single quotes instead of trimming the date first. 

[manion72]

First one...!    : )

Michael Manion

[pionut]

Hi,

This is my solution. All the best, IP

[manion72]

IP, thanks for sharing your solution--   Yes, I didn't know about the DateTime node when I posted my solution...  It is a *lot* easier than my brute force method!  I like the way you used the Custom format, I will do that myself in the future!    

Happy solving--

Michael

[matyohan]

Thanks!

[FeedMeData]

Here's my solution!

[robert-headington]

Not as good as the posted solution but it gets the right answer.

[JonathanAllenby]

Here's my solution to Challenge 2!