Regex match in filter tool

[jmc]

Hi, I'm new to regex. I'm looking to isolate any string with more than one letter C.

CCMM matched

CMCMCM matched

CM not matched

CCM matched

CMM not matched

CMMC matched

CMC matched

I tried REGEX_Match([Pairs],"/[c]{2}/")=-1 but didn't work. I also check with regex 101 looks like the repetition function only picked up all "c" if they're one after another (e.g. ccmm) not if they're between other letters (e.g. CMCM)

[MarqueeCrew · Accepted solution]

@jmc ,

 one way is:

regex_countmatches([field],"c") > 1

 cheers,

 mark

[jmc]

exactly what I need. Thanks Mark! @MarqueeCrew

[MarqueeCrew]

You're welcome 😇