Challenge #207: Parsing Video Game Data

[Paradox]

スポイラ

Parsed the headers into rows for the dynamic replace. Split the doubles first, then used Regex in the formula tool to create the other fields. Multi-column formula with ignore errors instead of replace().

[rayJ]

Practicing for Advanced exam, regex part. A wonderful challenge to hone my skill.

スポイラ

[Qiu]

worked hard.

スポイラ

[JoeBarndollar]

Used Regex and text to columns for the header. 

スポイラ

[JethroChen]

スポイラ

[jamielaird]

Here's my solution:

スポイラ

[LukaszKarpinski]

My solution:

スポイラ

[JamesMA]

A very tricky challenge.

I always avoid RegEx when I can so opted for formulas instead.

スポイラ

[WernerE]

スポイラ

Tried to not use regex and ended up with lets just say what an only be described as an extended workflow. Regex next time for sure.

[pawanmalik]

Nice parsing exercise.