Challenge #2: Preparing Delimited Data

[GeneR]

We hope you enjoyed last week's challenge. The solution has been posted here. For the second challenge lets look at removing characters and splitting data into columns based on delimiters.

Many products will export textual data with delimiters such as quotes. This is done so that strings can contain delimiters or control characters within them. Having more than one type of delimiter can be hard for ETL programs to interpret.  In the input text file, there are two different delimiters (double quotes, single quotes) and they surround different data types.

Use Alteryx to strip out the delimiters as superfluous and format the data as represented in the output.

You may notice that we have started classifying the exercises into beginner, Intermediate and advanced.  This classification is used by Alteryx internally to sequence exercises as users advance. 

Update 11/23/2015:

The solution has been uploaded.

[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 )  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.