community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #130: Is There an Echo in Here?

Quasar

Workflow shows both long was and single tool.  I figured early that it would be a Regex replace, but took a little time to get the format correct.

 

Spoiler
Workflow 130.JPG

 

Asteroid

I opted for the longer solution, while not dynamic, still gets the job done.

 

Spoiler
clipboard_image_0.png
Asteroid
 
Highlighted
Asteroid
Spoiler
challenge_130_solution_justindavis.PNG
Alteryx
Alteryx
 
Alteryx Partner
Spoiler
130.png
Alteryx
Alteryx

Not well versed in RegEx enough to get the one tool solution without looking at the answer  

 

Spoiler
Spoiler
echuong1_0-1575654365104.png
Alteryx Partner

Got it with one tool(!), albeit with a little help from Ask Jeeves (or some search engine....)

 

 

Spoiler
Process:

\b(\w+)(?:\s+\1\b)+

As I understand it (please correct me if I am wrong), this says that the match would need to be of the entire word (vs a portion of the word), it then compares each word to the next word (which is not in the marked group) and looks for a whole word (as the immediately adjacent word)

Then by setting the replace to ${1} it ensures the initial duplicated word remains


MySolution.PNG

 

 

Asteroid

I assume I need to build up some reg-ex skills but this seems to work!

Asteroid

Fun!

Spoiler
Annotation 2020-01-03 000940.png