Challenge #2: Preparing Delimited Data

[efrieler]

Challenge 2

[TheOC]

A nice challenge - not too tricky and only a few tools

Spoiler

[KirstySwales]

Nice first challenge

Spoiler

[PGraff]

I suppose the Data Cleansing Tool would have been a better way to go, lol.

[quantumudit]

Here goes my solution for the Challenge-2 :

Spoiler

Spoiler

[johnyli168]

Attached is my solution

Spoiler

I realised after I could've used StripQuotes[(String)] instead of having to use a data cleanse and formula (left & right) which would've tidied up the solution! 

[anujkgupta08]

Previously I used the long method to solve this challenge, I used two regex to replace the comas and datetime tool to convert string into date, later I thought its a lengthy way to solve so I modified and used formula tool to solve this problem. PFA the solution 

[TimN]

Spoiler

[Arindita369]

Here goes my solution for the Challenge-2 

[davetheman25]

My first challenge - love the variety of methods others used.