I’m trying to filter out words with multiple capital letters in cyrillic like in this example in google sheets:
ПредметыПапкиВзаимодействий
I’ve tried this one: \w*[А-Я]\w*[А–Я]\w
But it’s only showing acronyms like ЭДО, ЕГАИС, etc.
Could you suggest any solutions?
>Solution :
You can use
[А-ЯЁ][^А-ЯЁ]*[А-ЯЁ]
Or, if there can/should be no whitespaces between two capital letters you can use
[А-ЯЁ][^А-ЯЁ\s]*[А-ЯЁ]
Details:
[А-ЯЁ]– uppercase Russian letters[^А-ЯЁ\s]*– any zero or more chars other than Russian uppercase letters and whitespace[А-ЯЁ]– uppercase Russian letters