We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #130: Is There an Echo in Here?

hbraunius
8 - Asteroid

My solution attached.

JoshuaGostick
11 - Bolide

My solution 🙂

Spoiler
challenge_130.PNG
Kenda
15 - Aurora
15 - Aurora
Spoiler
Had to pull out some new RegEx tricks, but was able to get the one tool solution!

Capture.PNG
zachmiller
6 - Meteoroid

My solution! ...

Spoiler
challenge_130_zsm_solution.png
jwlong91
8 - Asteroid

Fun challenge!  I don't know if the Python tool counts as a one tool solution or not, but I wanted to try tackling this using Python to get some practice using the new tool!  I also tried using just base Python (except Pandas to create a new dataframe since Alteryx can only write out dataframes) and tried to avoid using regex.  I also added one more phrase "It's going to be a great great, fun-filled day day!" just to make sure I was still capturing the correct punctuation mid- and end-sentence.

 

Spoiler
Challenge 130 Screenshot.JPG
Challenge 130 Screenshot 2.JPG

 

Brian_Stoffel
8 - Asteroid

I had to do some research on RegEx but it seems to work.

TonyA
Alteryx
Alteryx

Beat my head against the one tool solution for a while but finally got is. I included the basic tools solution as well.

Spoiler
Took a lot of googling around regex sites to sort this out and then I had to figure out how to use the replace option.
PaulN
Alteryx Alumni (Retired)
 
LordNeilLord
15 - Aurora

38

 

Spoiler
Capture.PNG
Marcel_Gavrila
8 - Asteroid

Here's my solution!

Spoiler
Capture.PNG