Challenge #207: Parsing Video Game Data

[tristank]

Good regex practice

Spoiler

[clm_lamb]

My solution using regex tools

Spoiler

First I'm using regex parse method to split the dataset into several columns and collect only usefull informations, my pattern is : 

(\d+)(.+)\s(\w+)\s\((\d{4})\)\s\w{3}:(.+)\s\w{3}:(.+)\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million

Then I'm using regex tokenize method to rename column dynamically, my pattern is :
([^|]+)

[Filippo]

Just getting started with Regex. Surely not the most efficient way to do this but it worked.

[gawa]

Done

[Tejasvi17]

Solution

[nicks2587]

Completed

[Anita-til]

Got there.

Spoiler

 

[mithily]

Spoiler

used regex and struggled because I forgot to trim the field first- drove me nuts and wasted hours

[sarahkelly]

Kicked off my Friday morning with some sweet Regex. Attached is my solution to Challenge #207: 

[ArisaOkada]

My twenty-sixth workflow!