Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #207: Parsing Video Game Data

cplewis90
13 - Pulsar
13 - Pulsar

Decide to regex the headers and data.

Spoiler
Challenge 207.PNG
MOHAMMEDAFZAL
7 - Meteor

Hey all,

 

This is my 1st post so i am very excited. Do send responses on my solution and suggest improvements. 

 

Check it out!

 

Cheers,

Afzal

cc000072
8 - Asteroid

Here is my solution

CesarPicco
7 - Meteor

I got it in a very brute force method... I need to get so much better at RegEx parsing!

estherb47
15 - Aurora
15 - Aurora

One really long Regex Parse statement

 

Spoiler
EstherB47_0-1585625878405.png


(\d{7})(.+)\s(\w+)\s\((\d{4})\)\s\u{3}:(.*?)\s\u{3}:(.*?)\s\$([\d\.]+?)million,\s\$([\d\.]+?)million,\s\$([\d\.]+?)million,\s\$([\d\.]+?)million,\s\$([\d\.]+?)million

Sylvana
8 - Asteroid

I needed a little help to get the full parse string but it finally worked.

echuong1
Alteryx Alumni (Retired)

Definitely made it more complicated than it needed to be, but got the job done!

 

Spoiler
echuong1_0-1585679672988.png

 

jhustin
7 - Meteor

First time using the Regex tool. I really wanted to get it all done in one tool but the name/platform got me. Had fun and learned a ton!

KeithZ
8 - Asteroid
Spoiler
KeithZ_0-1585762147287.png

 

monicacorrea
5 - Atom

I hope you find this helpful!

Spoiler
challenge_207.JPG