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

Deborah_Simmonds
8 - Asteroid

Loved working through this in the JLL EMEA session, and working through multiple different solutions to each step!

SmitaLohande
8 - Asteroid

My Solution !!

e_d_g
7 - Meteor

my solution

 

 

bethgurske
6 - Meteoroid

#207 Solution 

chandler-gjino
Alteryx
Alteryx

attaching my solution

Wes_Seward
6 - Meteoroid

definitely need more practice writing regex code

alacoume
8 - Asteroid

My solution:

Dani_Lin
8 - Asteroid

solved

kmbassett01
8 - Asteroid

First crack at Regex - it took some doing, but I got there eventually!

Tom_Gould
7 - Meteor

Managed to parse all the data with one regular expression (in spoiler)

Spoiler
Screenshot 2023-08-10 112930.png
Spoiler
(\d{7})(.+)\s(\w+)\s\((\d{4})\)\sCAT:(.+)\sPUB:(.+)\s\$(\d{1,2}\.*\d{0,2})\w+,\s\$(\d{1,2}\.*\d{0,2})\w+,\s\$(\d{1,2}\.*\d{0,2})\w+,\s\$(\d{1,2}\.*\d{0,2})\w+,\s\$(\d{1,2}\.*\d{0,2})\w+