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.
Solved! Go to Solution.
Here goes:
Regex_Match([text],".*\u{2,}.*",0)
it will be true if ever ther are 2 caps together
cheers,
mark
@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!
Is this what you expect?