Challenge #207: Parsing Video Game Data

[Paradox]

Spoiler

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.

Spoiler

[Qiu]

worked hard.

Spoiler

[JoeBarndollar]

Used Regex and text to columns for the header. 

Spoiler

[JethroChen]

Spoiler

[jamielaird]

Here's my solution:

Spoiler

[LukaszKarpinski]

My solution:

Spoiler

[JamesMA]

A very tricky challenge.

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

Spoiler

[WernerE]

Spoiler

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.