community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #130: Is There an Echo in Here?

Alteryx Partner

Fun challenge! my solution:

Spoiler
challenge 130.jpg
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

 

 

Alteryx Partner

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

 

 

Spoiler
Capture.PNG
Asteroid

Got it :)

 

Alteryx Certified Partner

Got it in the one tool! 

Spoiler
wk130.PNG
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. 

Alteryx Certified Partner

Solution attached.

 

 

Meteoroid

Solution

Spoiler
image.png
Meteor

Easy with regex...

Asteroid