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

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
12 - Quasar

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

 

Spoiler
REGEX_Replace([Input Data], "\B[aeiouyAEIOUY]", "")
MarqueeCrew
19 - Altair
19 - Altair

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 reboot. Order shall return.
Please Subscribe to my youTube channel.
Luke_C
13 - Pulsar

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
16 - Nebula
16 - Nebula
Spoiler

patrick_digan_1-1615817188713.png

 

RolandSchubert
15 - Aurora
15 - Aurora
Spoiler
259.jpg