Challenge #2: Preparing Delimited Data

[IgnacioIrazoqui]

Hi everyone! I'm sharing my resolution.

I do a Text To Columns for separating the text, using the commas as a delimiter. Then, with a Formula Tool, I eliminate the doubles and single quotes. Next I convert the date, and that's all.

Thank u all!

Spoiler

[brennae1]

Sharing my solution to the challenge..

Spoiler

[mbreen497]

Spoiler

[JWadher]

Here is my solution - slightly long winded compared to the solution, but got there 🙂

[carmenrapariz]

Here's my solution!

[SahinC]

My solution:

[HCowley]

This is my attempt

[rohanonline]

Here's my solution.