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