RegEx replace ALL CAPS words of string

Hi,

Quite new to regex and I'm having a hard time wrapping my head around something I thought to be quite straight forward.

I have a set of strings consisting of a mix of words. I want to remove all words that are ALL uppercase, while saving all words with first letter uppercase (Proper) as well as all lowercase words.

E.g.

Input

"Car BLUE FAST EXPENSIVE"

"BLUE SLOW Railroad car CHEAP"

Output:

"Car"

"Railroad car"

Would be very grateful for any help with this!

Regex

Accepted answers

Maskell_Rascal

Hi @Yamariot

RegEx can get a little funny with case sensitive strings like this. My approach would be to split the data to rows, then use a Regex Match filter, and finally concatenate the results back again.

See attached workflow.

If this solves your issue please mark the answer as correct, if not let me know!

Thanks!

Phil

Remove ALL CAPS Strings.yxmd

Qiu

@Yamariot
Try with RegEx

New Workflow2BA.yxmd

All comments

Maskell_Rascal

Hi @Yamariot

RegEx can get a little funny with case sensitive strings like this. My approach would be to split the data to rows, then use a Regex Match filter, and finally concatenate the results back again.