Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

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

Submit Feedback
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.

Challenge #130: Is There an Echo in Here?

Highlighted
Alteryx Certified Partner

Fun challenge! my solution:

Spoiler
challenge 130.jpg
Highlighted
8 - Asteroid

Hello,

 

Although i tried the regex way I could not get it to work however I did it really quick using many tools. I am struggling a bit learning the regex way, does anyone know of any online courses/documentation which is not incredibly complicate! I did find this cheat sheet which has been helpful doing some bits https://www.cheatography.com/davechild/cheat-sheets/regular-expressions/pdf/ in other work!

 

Spoiler
130.PNG

 

 

Highlighted
Alteryx Certified Partner

I've added a 3rd option. Spoiler alert: it's a game breaker! :D 

 

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid

Got it :)

 

Highlighted
Alteryx Certified Partner

Got it in the one tool! 

Spoiler
wk130.PNG
Highlighted
7 - Meteor

I know this is probably one of the longest ways around, and I know the "one tool" would be the RegEx tool, but I am not that well versed in it and got tired of beating my head against the wall, so...  here is my "working" solution.  The main downfall is that if the original text string has more than 1000 words, then it will not work properly.  I will definitely be looking at other, more efficient solutions. 

Highlighted
Alteryx Certified Partner

Solution attached.

 

 

Highlighted
6 - Meteoroid

Solution

Spoiler
image.png
Highlighted
7 - Meteor

Easy with regex...

Highlighted
8 - Asteroid