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 #130: Is There an Echo in Here?

piotrzawistowski
8 - Asteroid

My version with Regex.

viveknshah
8 - Asteroid
Spoiler
challenge130_viveknshah.JPG

The University class on RegEx to the rescue! 

fmeo
8 - Asteroid
Spoiler
130.PNG
RWvanLeeuwen
11 - Bolide

I can't seem to even interpret the RegEx of the one tool solutions. Just something about capture groups and juggling them around. So if anyone has a helpful read on that for me, thanks in advance.

 

Here's my multi-tool approach:

Spoiler
130.png
Zuza
8 - Asteroid
 
ddiesel
13 - Pulsar
13 - Pulsar

I knew the one tool solution was a RegEx Replace formula but I couldn't quite get the syntax right. 

 

My solution:

Spoiler
Capture.JPG
mbogusz
9 - Comet
Spoiler
Breaking out my text-to-columns and cross tab!Breaking out my text-to-columns and cross tab!

Thank you @neilgallen for the easily understandable solution.

markcurry
12 - Quasar

Here's my solution.

chetty
8 - Asteroid

My solution attached

OllieClarke
15 - Aurora
15 - Aurora

Got that one tool solution, but holy nested REGEX batman...

Spoiler
Challenge 130.png

edit: just looked at some other solutions and I really overcomplicated this...