Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

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

sknman92
8 - Asteroid

fun with regex! solution attached

clairelardner1
5 - Atom

S/O RegEx

JRBeaudry
8 - Asteroid

A very nice little one ! 😎

 

Spoiler
Nice use case of parse and grouping in RegEx!
2023-12-15 14_51_19-Alteryx Designer x64 - challenge_207_start_file.yxmd.jpg
StephanieYou
8 - Asteroid
Spoiler
Screenshot 2023-12-20 174239.png
snbandi
8 - Asteroid

Getting introduced to the world of Regex. Coming from structured ERP world where this is never a thing.

DataCruncher4
7 - Meteor

challenge 207solution

boroalicja2
8 - Asteroid

my solutions

asultanov
8 - Asteroid
Spoiler
quite a mouthful but it works 
(\d{7})([\w\s:\.&/\-é!]*)\s(\w{2,4})\s\((\d{4})\)\sCAT:([\w-]+)\sPUB:([\w\s-]+)\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million,\s\$(.*)million

Screenshot 2024-02-08 171116.png
danbostrom
8 - Asteroid

 

 

Rhys_Cooper
9 - Comet

Excellent Regex practice!

 

Spoiler
Capture.JPG