Challenge #2: Preparing Delimited Data

[Sus7]

This is my first challenge attempt. Solved this a bit differently. I have used 'Data Cleansing' tool and 'DateTime' tool.  Attached the Solution here:

[annaprosvetova]

Great little challenge to refresh Alteryx skills.

[Slacker]

My Solution

[byagelski]

my solution

[PaulGriffiths]

I enjoyed that

Spoiler

[SimonEvans]

Solved

Spoiler

[Emily_P]

Done!

[mpoon]

My solution is slightly different from the given solution.  I used the trim function to remove excess quotations and datetime tool to fix up my date column.

[jeremyhaber814]

Challenge 2

[EmmyCC]

This is a very clever challenge, I spent a long time figuring how to trim " and ' , then I decided to treat them both as delimeters then parse each record into 5 fields (date, mon, year are three fields), then I use formula tool to combine them all together back to a new field.... it worked but knowing how to deal with quotes and single quote in expression is very important. Thanks I have learned that from this challenge 🙂