Filter records which have 2 or more capital letters together

vlad_kutateladze

Hi,

I have two type of records in dateset

Example1: GasStation

Example2: titaniumMOBILEPHONES

I need to separate words. I first case I separate them by capital letters, but for second type of data it not works.

How can I filter records which have 2 or more capital letters together?

Thanks.

Output

Accepted answers

Here goes:

Regex_Match([text],".*\u{2,}.*",0)

it will be true if ever ther are 2 caps together

cheers,

mark

All comments

Here goes:

Regex_Match([text],".*\u{2,}.*",0)

it will be true if ever ther are 2 caps together

cheers,

mark

vlad_kutateladze

@MarqueeCrew Thank you!

Hello Mark,

Quick question on this Regex (brilliant by the way), how could I filter records that start with two capital letters? So only the first two letters need to be capitalized in order to be filtered.

Thank you!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15880

MarqueeCrew 13708

apathetichell 13703