Challenge #2: Preparing Delimited Data

[prasanna2016]

Here is my Solution

[cyow]

my solution

[John_xyz]

Spoiler

my_solution

 

Spoiler

my solution

 

[zchen1]

My Solution

[Ivy_Lim]

took me 6 steps but it worked

[danielhoge]

alright alright alright!

[Sajuli1]

I did it through Regex tool (parse option)

[Katinasg]

Done

[IraWatt]

Spoiler

Used text to columns a formula tool then datetime tool. 

 Great challenge. 

[Krzysztof_Hyla_1986]

I used 'Text To Columns' and  'Formula' tool to solve this. 

Alternatively 'DateTime' parse tool can be used to convert the date.

Spoiler