Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI 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!
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