Challenge #2: Preparing Delimited Data

[Thomas_W]

Solution attached

[Erin]

Hello,

Took at stab at it and submission attached. 

Spoiler

I almost missed converting the Poem_Read_Date to an actual date type. 

[dwhitmoyer]

Challenge #2

[joelmiller66]

Spoiler

[moakman]

Here is my solution to the challenge.

[Ridler]

Spoiler

[cherrington]

Challenge reply

[Akash_chauhan]

My Solution of Challenge #2: Preparing Delimited Data

Please share your feedback because it matters 🙂.

[TKSnider]

Ok, only a few years late to the party (probably a bit much to be socially late, I suppose :p)  I did not read through the posts to see how others did this, as I like to struggle through on my own to figure it out, I learn more that way!

Spoiler

For me, I used a text to columns, then a multi field formula to get the mid characters of the two text fields.  Converted the id column to int16 and then used a datetime tool to convert the date using a custom (dd-Mon-yy) format.  a final select to remove the original date field and I had success 🙂

[jharber]

My solution to Challenge 2.