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 currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

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 #259: Disenvowel

JoshuaGostick
11 - Bolide

My regex solution

 

Spoiler
challenge_259.PNG
hanykowska
10 - Fireball

Done 😄

 

Spoiler
hanykowska_0-1633710891308.png

 

Sebastiaandb
11 - Bolide

Well, thank god for Regex and @MarqueeCrew making this challenge a piece of cake. 

For all those trying to solve this riddle, it's really helpful to understand Regex and i especially recommend you to read.

 

https://community.alteryx.com/t5/Engine-Works/Accepted-Solution-Deep-Dive-to-RegEx-or-Not-to-RegEx/b... 

 

 

Spoiler
Sebastiaandb_0-1634710029858.png

Just make sure you understand what the regex does! \B stands for a non word boundary and the letters within [ ] means "a single character presented", thus REGEX_Replace([Input Data], "\B[aeiouyAEIOUY]", '') means to replace all those characters by nothing except if they're a word boundary :-). 

Copy pasting solutions is easy, understanding them is the part that you really should learn yourself to do :-). Force yourself to solve those weekly's with your own knowledge and only allow yourself to dive into tool mastery pages to get to the answer, it's the only way to get a really decent understanding of Alteryx.