Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution,
(\b[aeiouy])|[aeiouy]
and replacing with `\1`.
But better solution from @Maskell_Rascal
\B[aeiouy]
These are the only reason I look forward to Monday mornings 😊 Love the Regex Tokenizer - made this nice and easy.
Fun little exercise. But the best part was the name 😀.
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.
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?
This can be done as a one-liner! I suggest at least one more test case: "You and I" should become "Y an".
Substring([Input Data],0,1) + REGEX_Replace(Substring([Input Data],1), "[aeiouy]", "", 1)