Challenge #2: Preparing Delimited Data

[SeanAdams]

Welcome to the community Rob - you're well on your way to cracking your first 5!

[nick_ceneviva]

Solution attached

[derekbelyea]

Solution attached

[JORGE4900]

On my solution, I ended up using two regex tools to remove the single and double quotes, but I like the use of the formula tool with the trim function. I thought it was very clever to use the DateTimeParse function while trimming the date field; I wish I would have thought of that when I was doing it. Good job.

[JORGE4900]

Kuddos @Max06270; your approach really simplified the solution.

[ADerbak]

Completed! See attached...

[michael_d]

Still playing catchup :)

[mceleavey]

Don't think of it like that. Think of it like there's plenty more puppies and chocolate left.

[Beastmode314]

Solution Attached

[LelandM]

Solution attached