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

RobertW
Alteryx
Alteryx

I ❤️ Video Games

 

Spoiler
RobertW_0-1584634686202.png

 

rboehner79
6 - Meteoroid

Great RegEx practice, but I would've never figured this out how to use the RegEx without the solutions from others here!

 

Also shout out to @JORGE4900 -- that link is a great help!

 

 

JennyMartin
9 - Comet
Spoiler
AWC207.PNG

Good regex exercise! Watch the video solution here: https://youtu.be/E1ePcobXtBg

Joe_McCoy
8 - Asteroid

That was a workout for a regex novice.

DannyS
Alteryx Alumni (Retired)

Solution attached.

 

Tools used: Select Records, Text to Columns, RegEx, Select, Dynamic Rename

 

DannyS_0-1584654551598.png

 

alozano
8 - Asteroid

Good practice for Regex:

 

Spoiler
challenge_2017_alozano.jpg
dsmdavid
11 - Bolide

Good regex fun. Probably not easy to debug though --having all the parsing in just one tool. but...

Spoiler
dsmdavid_0-1584656450273.png
(\d{7})(.*?)\s([\w\-]+)\s\((\d{4})\)\sCAT\:([\w\-]+)\sPUB\:([\w\-\s]+)[^\$]+?\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)[^\$]+\$([\d\.]+)

 

Not a fun of how the tool "forgets" the names that you had labourously typed everytime you forget then remember a missing bracket. Quite useful to edit in the xml window in those cases.

Spoiler
dsmdavid_1-1584656890234.png

 

kylemhabe
8 - Asteroid
Spoiler
kylemhabe_0-1584715163315.png

 

Carlithian
11 - Bolide
11 - Bolide

loved this challenge, gave myself and extra challenge of parsing it with a single regex formula 🙂 

Amin
8 - Asteroid

 

Spoiler
207_Amin.PNG

Easily the longest attempt I've sat through for a weekly challenge...

Used https://regexr.com to expedite but had to review my regex expression against other's solutions repeatedly to investigate broken points.

Would be lovely if regex can be friendlier to us. 😛

If you find that the Regex experience can be improved, you may want to like this idea here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/RegEx-let-s-make-it-easier/idi-p/75238