Challenge #207: Parsing Video Game Data

[Jean-Balteryx]

Here is my solution !

[huynv96]

Regex powerful!

Spoiler

[RWvanLeeuwen]

Fun challenge with few tools required.

Workflow:

Spoiler

I could show you the RegEx as well if you want:

Spoiler

^(\d{7})(\w.*)\s(\w{2,4})\s\((\d{4})\)\s?CAT:(\w.*)\sPUB:(\w.*)\s\$(.+)million,\s\$(.+)million,\s\$(.+)million,\s\$(.+)million,\s\$(.+)million$

[kelly_gilbert]

Great regex practice! My solution is similar to many others.

Spoiler

Parsing game info:




Parsing sales:

[IgnacioIrazoqui]

Hi!

I did RegEx and Text to columns, basically.

Spoiler

 

[AbhilashR]

Regex all the way

[knlekash]

Learned some new regex tricks here!

[Maha]

[ken_yap_au]

Done!