Challenge #207: Parsing Video Game Data

[olga_strubbe]

This was a neat parsing challenge, gave me a chance to practice my RegEx. 

My solution using just 2 tools is attached (not counting the browse tool :))

[Shadi_Rasolpour71]

Done.

[aaroncpotts]

I focused on working on this one using only my own knowledge of Regex and various tools, and less on trying to find the most efficient solution. That said, other than a few weaknesses in the Regex tools where it isn't necessarily future-proofed, I'm satisfied with this.

Spoiler

 

[Rob-Silk]

Solution attached below:

Spoiler

RegEx used for data parsing:

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

[BenjaminBreton]

not sure my Regex expression is the best but I made something that works 😊

[Amy_smart]

Here is my solution.

[mgaronson]

Spoiler

 Checking other solutions ... regex tokenize to columns for the $ columns is brilliant! Next time.

[adamweaver39]

Used @johnemery 's video tutorial to help out with the RegEx syntax -- huge help and great practice!

Spoiler

[KosukeUchihashi]

Solution attached.

[Mikeimbi]

Challenge 207