Case Sensitivity in Lookup Table is Not Working

CForman
CForman Altair Community Member
edited March 2023 in Community Q&A

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.

Tagged:

Best Answer

  • Lasse
    Lasse Altair Community Member
    edited March 2023 Answer ✓

    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

Answers

  • Lasse
    Lasse Altair Community Member
    edited March 2023 Answer ✓

    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

  • CForman
    CForman Altair Community Member
    edited March 2023

    That was what I needed!  Thank you so much, I was not familiar with that function.  I really appreciate the help.

  • Lasse
    Lasse Altair Community Member
    edited March 2023

    You're welcome. Happy to help :)

Categories