Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found herewooden-cubes-2x1.jpg

 

This week's challenge was submitted by @MarqueeCrew  based on this post - Thanks for your submission! Be sure to check out the accompanying blog post!

 

In this challenge we need to create a workflow to remove vowels from text, excluding vowels that are the first letter in a word. Y is included as a vowel for this challenge...

Aaron_Harter
11 - Bolide

Arn cmpltd!

Spoiler
1.PNG
Maskell_Rascal
13 - Pulsar

Fun little RegEx challenge to start the week! Here is my solution. 

 

Spoiler
REGEX_Replace([Input Data], "\B[aeiouyAEIOUY]", "")
MarqueeCrew
20 - Arcturus
20 - Arcturus

Here's my blog post about the original post:

 

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

 

I do encourage everyone to explore that blog and the original post.  Please do comment along the way.  

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Luke_C
17 - Castor

Tried with the usual formula approach I would use, and also learned something new with the regex method mentioned in original thread

 

Spoiler
Luke_C_1-1615814691180.png

 

Blake
12 - Quasar

All st on ths chllng

 

Spoiler
259.png

 

 Chck ot m vd sltn blw

(Check out my video solution below)

Spoiler
jferrone
8 - Asteroid
Spoiler

Chllng Cmpltd

jferrone_0-1615815182191.png

This is a different approach as I haven't really used Tokenize. Results matched. Reattached solution workbook with both options. 

jferrone_0-1615816398243.png

 

DeanWest
9 - Comet

Fun one-tool challenge! :formula:

 

Spoiler
challenge_259_Solution_DeanWest-snippet.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler

patrick_digan_1-1615817188713.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
259.jpg