Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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