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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

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
11 - Bolide

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

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
8 - Asteroid

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