Challenge #2: Preparing Delimited Data

[Santhoshkumar1]

Solution

[JosephAskew]

Fun challenge. 

[jaeheehwang]

Completed 

[barxdavid99]

Took me a couple extra steps but I got it!

Spoiler

Spoiler!

[anthonyw]

My solution has been attached

[dougbaron]

I came to the same results, but could have combined the the date conversion into a single step in the formula tool. I also noticed the Poem field length got shortened, so I matched the size in the Select tool.

[Archie_bos]

[geraldngugi]

My solution using RegEx

[KrishnaChithrathil]

Spoiler

[danblythe_RSM]

Spoiler

I love RegEx!