Remove all vowels from a string unless it is the first letter of a word.

I want to remove all vowels from a string of words : a, e, i, o, u, y. UNLESS its the first letter of a word.

Example:

Ground Control = Grnd Cntrl

Universal Control = Unvrsl Cntl

Regex

Accepted answers

This FORMULA will eliminate non-1st letter Vowels.

REGEX_Replace([Field1], "\B[aeiouAEIOU]", '')

\B = non-word boundary (meaning, it isn't the first letter of a word).

[] = set of letters (lower or uppercase vowels)

Cheers,

Mark

Here an example

I hope it helps

You can use a RegEx replace function to achieve that. Just make sure that you add the 0 at the end to make it case sensitive

Any updates on this @hellyars ?

This FORMULA will eliminate non-1st letter Vowels.

REGEX_Replace([Field1], "\B[aeiouAEIOU]", '')

\B = non-word boundary (meaning, it isn't the first letter of a word).

[] = set of letters (lower or uppercase vowels)

Cheers,

Mark