Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #297: Rubik Cube

jeffrey_angeles
7 - Meteor

Done.

Spoiler
Capture.PNG
ShaheenArshiya
8 - Asteroid

Completed!

cjmayes
8 - Asteroid

:)

mnmemilymnm
8 - Asteroid

I struggled with the RegEx tool a bit and ended up using two RegEx tools to accommodate the fact that some country names are comprised of two words rather than one. I could have used the Text to Columns tool to parse out country name as everything before the comma, but I really wanted to get the RegEx tool to work. I'll check out how others used the RegEx tool so I can see how it can be done in a single step!

Qianru
8 - Asteroid

My Solution

emartz
Alteryx Alumni (Retired)

Late Solution.  It looks very similar to others I reviewed.

mgaronson
11 - Bolide

Looking at the workflow, it  seems complicated but it is not. Just had to figure out the bonus - way easier than I thought it would be!

SylwiaDragon
8 - Asteroid

Done

gambiera
6 - Meteoroid

You want to capture anything up to the first comma. One way you can do this in RegEx is like this:

 

^([^,]*)

 

Decoded:

^     = start of string
(     = begin matching
[^,]  = any character except ","
*     = repeat, greedily
)     = stop matching