Case Sensitivity in Lookup Table is Not Working

CForman

I have a data extract from one of our systems, in which I'm attempting to find any lowercase values in a particular column.

I see in the help file that this cannot be done using a function comparison in a filter, i.e. "Field = lower(Field)", as filter expressions are not case-sensitive.

So I'm trying to accomplish it using a lookup table, where I've entered 26 input values, one for each lowercase letter, using "Input Field Contains Input Value" for matching (rather than "Exact") and have Case Sensitive checked.  When I do this it pulls the lowercase fields, but also a bunch of uppercase values as well.  (But not the entire dataset.)

Is there any way to accomplish what I am trying to do in Monarch? 

Thank you for your assistance.

Lasse

Hi Chris,

What about a formula-based filter with expression: RegexIsMatch(Field;"[a-z]"). This will filter all rows with a lowercase letter in the Field-column.

Sorry if I didn't understand your question correctly and this solution doesn't work for you.

-Lasse