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.

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
Alteryx

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

mgaronson
8 - Asteroid

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