Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #207: Parsing Video Game Data

Highlighted
12 - Quasar
12 - Quasar

Decide to regex the headers and data.

Spoiler
Challenge 207.PNG
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

Highlighted
8 - Asteroid

Here is my solution

Highlighted
7 - Meteor

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

Highlighted
14 - Magnetar
14 - Magnetar

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

Highlighted
8 - Asteroid

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

Highlighted
Alteryx
Alteryx

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

 

Spoiler
echuong1_0-1585679672988.png

 

Highlighted
5 - Atom

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!

Highlighted
8 - Asteroid
Spoiler
KeithZ_0-1585762147287.png

 

Highlighted
5 - Atom

I hope you find this helpful!

Spoiler
challenge_207.JPG