Challenge #2: Preparing Delimited Data

[rajenderk18]

It is easy on. I just use a text-to-column tool to convert text into column, formula tools to remove extra quotation and parse the string into text and then I use the select statement for renaming and selection of particular column.

[shyamraman]

Hello,

Here is my solution, I parsed the text for , and ", and used the datetime tool.

Thanks

Shyam

[Sameera]

Spoiler

[mkhan135]

I also used an exactly similar approach. Can you suggest a way to reduce the number of tool used for the problem?

[KOON]

Here it is

[vivanreddy_dup_583]

Challenge #2

[george11]

my solution

[andre_manente]

This is my first challenge.

Many thanks.

[Cmacp433]

Thanks for the practice

[kzrolfes]

Spoiler