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)