Challenge #2: Preparing Delimited Data

[smerton]

Just tried this one out. Here is my solution.

[vball5]

Here's my solution. 

[dcraft]

Challenge accepted! I took the route of text to columns, then the DateTime Parsing tool. I have to admit, I struggled with several approaches with other tools before landing on this one (and probably took more time than I'd like to admit!).

Thanks!

[bkinn]

Here is what I did!

[Amarendra]

Attaching the solution for challenge 2. 

[Amarendra]

Updated my solution after parsing the date filed. 

[PhilipMannering]

Spoiler

The only one to use the tokenize feature in the Regex Tool?

Solution attached.

[alexoreilly]

completed!