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?

sh0kat
7 - Meteor
Spoiler
REGEX_Replace([Phrase],"(\b\w+\b)\W+\1","$1")

challenge_130_Solution_Shokat.PNG
RogerA
8 - Asteroid

I tried recreating this, this way but after my concat on the summarize tool, it adds commas between each word.  Yours doesn't do this, do you know why?

 

 

pasccout
8 - Asteroid

Here is my solution... 

NilsM
8 - Asteroid
Spoiler
Challenge130.PNG

My solution

soha-elghany
8 - Asteroid
Spoiler
Spoiler 

Picture2.png
jackieheer
8 - Asteroid
 
Carlithian
11 - Bolide
11 - Bolide

Nice to make use of multi row formula

yajing_wang
8 - Asteroid

not a one tool way, regex is powerful but not good at it though, need to learn more

 

Spoiler
Spoiler
12.PNG
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

cgoodman3
14 - Magnetar
14 - Magnetar

My solution, never came across Regex before using Alteryx and it's proving to be so useful!

 

 

 

 

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com