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 updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

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

PhilipMannering
14 - Magnetar
14 - Magnetar

My solution,

 

Spoiler
I was using,
(\b[aeiouy])|[aeiouy]​

and replacing with `\1`.

But better solution from @Maskell_Rascal 

\B[aeiouy]
LHolmes
9 - Comet

Ths ws an excllnt chllng!

 

Spoiler
259 - Solution.PNG
apathetichell
15 - Aurora

I was trying to do this as a one tool REGEX and could get it to skip the first vowel on the line - but not in each word...

JP_SDAK
8 - Asteroid

These are the only reason I look forward to Monday mornings 😊  Love the Regex Tokenizer - made this nice and easy.

Spoiler
JP_SDAK_1-1615828996064.png

 


 

abrouwer
8 - Asteroid

Solution attached

Milanz
8 - Asteroid

m sltn 😉

 

Spoiler
Milanz_0-1615831290455.png

 

TC_bot
8 - Asteroid
Spoiler
TC_bot_0-1615833259793.png

 

TonyA
Alteryx
Alteryx

Fun little exercise. But the best part was the name 😀.

Spoiler
2021-03-15_11-53-10.png

Just looked at some of the other results. Never ran into \B before. A lot cleaner than [^\s].

That's why I do all of these -- even the simple ones. You can always learn something new. 

 

MarqueeCrew
19 - Altair
19 - Altair

@hellyars ,

 

 if you can trust capitalization .... 

 

eliminate the AEIOUY and UAS stays UAS. 

I'd use a find replace tool to identify text with words that I don't want to change.  Theoretically if use a replacement (__001__), run the data through the tool and then another find replace to restore the word.  I'd probably do this with the non-RegEx solution.  

care to give that a try?

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Please Subscribe to my youTube channel.
mike_w
8 - Asteroid

This can be done as a one-liner! I suggest at least one more test case: "You and I" should become "Y an". 

 

Spoiler
mike_w_0-1615837218983.png


Substring([Input Data],0,1) + REGEX_Replace(Substring([Input Data],1), "[aeiouy]", "", 1)