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
Alteryx
Alteryx

I ❤️ Video Games

 

Spoiler
RobertW_0-1584634686202.png

 

Highlighted
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!

 

 

Alteryx Partner
Spoiler
AWC207.PNG

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

This week's challenge is deceptively tricky and we need our good old friend regex to help us out in a dynamic way. Regex: (^\d+)(.*?)\s(\w+)\s\((\d+)\)\sCAT:...
Highlighted
7 - Meteor

That was a workout for a regex novice.

Highlighted
Alteryx
Alteryx

Solution attached.

 

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

 

DannyS_0-1584654551598.png

 

Highlighted
8 - Asteroid

Good practice for Regex:

 

Spoiler
challenge_2017_alozano.jpg
Highlighted
Alteryx Partner

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

 

Highlighted
8 - Asteroid
Spoiler
kylemhabe_0-1584715163315.png

 

Highlighted
8 - Asteroid

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

Highlighted
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