Looking for Starter Kits? Head to the Community Gallery! Now formatted as YXIs for easy installation.
alteryx Community

# Weekly Challenge

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.

## Challenge #207: Parsing Video Game Data

Alteryx

A solution to last week's challenge can be found here.GIPHY

Video games have become a ubiquitous part of culture over the past few decades. What started as giant consoles became miniaturized for use at home. As popularity increased and technology advanced, more titles were offered by various companies. Whether you wanted to be a frog hopping across the street, stack odd shapes falling from the sky, or defeat the dreaded space invaders, there was a game for you.

Over time, many companies innovated with different categories of games which expanded or create new genres. These games were made available for a variety of platforms - the hardware running the games.

This week's challenge is to parse the provided video game dataset into columns.

16 - Nebula

Regex to the rescue....again. Solution attached.

Spoiler
Workflow

And with three tools

Spoiler

Where the regex used is,
``(\d+)(.*) (\w+) \((\d+)\) CAT:(.*) PUB:(.*) \\$(\S+)million, \\$(\S+)million, \\$(\S+)million, \\$(\S+)million, \\$(\S+)million``
12 - Quasar

I'm not going to pretend that this is pretty... or efficient... but it works!

Spoiler

I don't play video games like I used to but this has made me nostalgic for some Mario Kart 64!

11 - Bolide

Some tricky regex in here. These challenges are excellent practice for regular expressions.

I posted a video of my solution here: https://youtu.be/I80eCfDph2Y

Spoiler

16 - Nebula

Managed to solve without RegEx ...

Spoiler
11 - Bolide

Great RegEx practice for this challenge:

Spoiler

(edit 3/16 12:20 CDT) Video of solution overview:

Spoiler
5 - Atom

Used Regex and tried to use minimal number of components

12 - Quasar

Solution attached.

Alteryx

Solution attached.

Attempted to use only 1 RegEx tool to parse a significant amount of the data.

17 - Castor
Spoiler