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
14 - Magnetar
14 - Magnetar
Spoiler
Could've done it in two tools but had to add a stinkin' Select to get rid of the original field.
Annotation 2020-03-17 134211.png

Highlighted
7 - Meteor

Interesting RegEx manipulation

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

my solution loved building the Regex  

Highlighted
8 - Asteroid

My solution attached.

Highlighted
8 - Asteroid

I love parsing Regular Expressions; however, it is very useful to use a website like https://regex101.com/ to help you identify groups and characters matched. This approach makes it easy to see if you should use a single digit--(\d) in a group or use zero or more digits--(\d*).

 

https://regex101.com/ Here

Spoiler
2020-03-17_12-38-32.jpg

Workflow Here

Spoiler
2020-03-17_12-37-02.jpg
Highlighted
8 - Asteroid

Here is my solution. The task was really interesting!

12 - Quasar
12 - Quasar

Currently playing Marvel Superhero Alliance 3 - and just like I've had to finish a few battles - Use BRUTE FORCE!  (And of course REGEX)

Highlighted
Alteryx Certified Partner

I do love me some parsing

Spoiler
Challenge 207.PNG
Highlighted
Alteryx Certified Partner

@PhilipMannering now you're just showing off

Highlighted
7 - Meteor

Regex change my life, it is such a wonderful thing.

 

I tried to challenge myself and just use one Regex tool on this one. 

 

Spoiler
dkoenawan004_0-1584486668383.png