Filter out all caps records

Hi,

I have data where I am trying to remove the row if a spefic field is in all caps. I thought I may be able to count lowercase characters, and filter out the zeros, but I am not sure why I am getting an incorrect result from my formula. Any ideas? Thank you.

Formula: REGEX_CountMatches([Task Name], "[\L]")

Task Name Count

DEMOLITION 0

D.O.T. Approaches 4

Sidewalks 0

Transformer Pad 1

Regex

Parse

Preparation

Accepted answers

HI,

try with

REGEX_CountMatches([Column], "\u", 0)

\u means uppercase, 0 is needed if you want to activate the case sensitive.

All comments

Can you do [A-Z] instead of [\L]?

Thanks John,

That doesn't seem to specifically count lowercase only characters. It looks like it is just counting all letters.

I am not sure what [\L] is counting either though, but it is pretty close to what I am trying to do.

challenge_128_start_file.yxmd

Quick Links

Tags

This months top contributors

AkimasaKajitani 389

michael_weaver 335

Hollingsworth 335