Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

PhilipMannering
16 - Nebula
16 - Nebula

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
18 - Pollux

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

 

Tony_Castillo
9 - Comet
Spoiler
TC_bot_0-1615833259793.png

 

TonyA
Alteryx Alumni (Retired)

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
20 - Arcturus
20 - Arcturus

@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 restart. 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)