Challenge #2: Preparing Delimited Data

[DaveMcCurley]

Looks like there are a lot of ways to get to the solution!

[AlexvanOs]

My Solution:

Spoiler

Again RegEx parse, then just to keep it green, the datetime tool (could be a nice blue formula tool if preferred), then select and presto!

 

[LiuZhang]

My attempt before learning RegEx

Spoiler

[Favian1]

My Solution

[PatForData]

Solution Attached

[alishadhillon__]

Probably my second attempt in a while and it still wasn't as straightforward as I thought it would be. Had a good go practising my regex skills! 

[yongjiawei1985]

My first attempt

[drexelchin]

My solution

[Kanishkas5301]

Spoiler

 

[rockyw9]

See attached 🙂