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?

T_Willins
14 - Magnetar
14 - Magnetar

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

 

bjkay30
8 - Asteroid

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

 

Spoiler
clipboard_image_0.png
Inactive User
Not applicable
 
justindavis
10 - Fireball
Spoiler
challenge_130_solution_justindavis.PNG
EmilyCR
Alteryx Alumni (Retired)
 
meeravijayan2011
8 - Asteroid
Spoiler
130.png
echuong1
Alteryx Alumni (Retired)

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

 

Spoiler
Spoiler
echuong1_0-1575654365104.png
SueDonim
8 - Asteroid

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

 

 

Benbryans
8 - Asteroid

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

tiffany_chen
8 - Asteroid

Fun!

Spoiler
Annotation 2020-01-03 000940.png