Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Really enjoyed this one! Lots of Regex practice. 

Spoiler
BS_THE_ANALYST_0-1672857798717.png
BS_THE_ANALYST_3-1672857851661.png

 


(\d+)(.*\s)(\w+\s)\((\d{4})\).*CAT:(.*)\sPUB:(.*)\s\$([\d|.]+)\w+,.*?\$([\d|.]+)\w+,.*?\$([\d|.]+)\w+,.*?\$([\d|.]+)\w+,.*?\$([\d|.]+)\w+

 

All the best,
BS

LinkedIN

Bulien
beckchel
6 - Meteoroid

My solution.

FinnCharlton
13 - Pulsar
Spoiler
FinnCharlton_0-1673863648005.png

 

MCooper
8 - Asteroid
Spoiler
C207.PNGC207regex.PNG
François_Rs
8 - Asteroid
Spoiler
Franois_Rs_0-1675700488139.png

 

Daniel1127
8 - Asteroid

Solution as attached. 

 

Using the tokenize function to remove the $ and 'million' for those dollar amount. 

 

Regular Expression: \$([^A-Z]+)[A-Z]+

SmitaLohande
9 - Comet

My Solution!

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1676994373091.png

 

caitlynle11
8 - Asteroid

caitlynle11_0-1677061080894.png

It took me a while to figure out the RegEx but finally! :)

 

CeliaC_Silje
8 - Asteroid

Again RegEx saves TIME

Spoiler
CeliaC_Silje_0-1677660674360.png