Free Trial

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