Challenge #2: Preparing Delimited Data

[realdaniel1989]

Spoiler

[drintoul]

Spoiler

[jchua3]

solved using a different method. refer to attached solution 

[7alexander17]

Solution attached

[Xiaoqi]

Spoiler

 

I use RegEx tool and DateTime tool.

[AngelosPachis]

This is my workflow for Challenge #2. The solution helped me learn how to use the datetimeparse function in a formula, which was super useful.

[JA]

My solution

Spoiler

[cfine]

Spoiler

Spoiler

[catherinefoster]

My solution using the text to columns, data cleanse and datetime tools:

Spoiler

[Ronald_Do]

Spoiler

Spoiler!

See solution attached!