Challenge #2: Preparing Delimited Data

[Ncardenas]

Here is my submission for the challenge!

Please see pictured my progress from my first attempt (above) to my last attempt (below).

Instead of using the formula tool to change the Poem_Read_Date to a "Date" datatype column with the DateTimeParse function, I opted for the DateTime tool. Also, to remove the double quotes I used the string function StripQuotes.

This helped me reduce the number of complex formulas used but at the cost of a larger file size.

I tried to cut down my first attempt as I noticed my use of tools was a little unorganized.

[FredNajjar]

Spoiler

[asriniv8]

I just competed the workflow, please review and share your feedback.

[jcollake]

Spoiler

[glry6001]

Spoiler

[JoaoLeiteV]

I've used Regex again to parse the data. When I first started learning Alteryx my teacher gave us this exercise when teaching about the basics of data parsing.

Spoiler

[siddharth_28]

Re: Challenge #2: Preparing Delimited Data

[Elias_Nordlinder]

My Weekly Challenge #2

Spoiler

[Menkova]

Here is my solution

[BenoitC]

Done! I used DateTime tool to format the time.