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.   

[MarqueeCrew · Accepted solution]

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! 

[zeb27]

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!

[sparksun]

Is this what you expect?