In a list of data i have uppercase letters and lowercase letters. I want to filter the data which contains only uppercase letters, lowercase later and mixed both upper and lower

MM Metro shoes are converting to Mm Metro when title the data set. For that I want to filter the data which is fully in uppercase or fully in lower case and mixed both upper and lower

I want to filter cases like (MOHAN METRO or mohan metro or mohan Metro or MOHAN metro) and want to change the filtered data. is there any possibility to filter that in QGIS

  • 2
    can you clarify what you want as output to all those cases?
    – Ian Turton
    Jan 19 at 8:30
  • @IanTurton i just want to filter the cases. thats it.
    – Bruno B
    Jan 19 at 10:09

1 Answer 1


Just filter by comparison to their UPPER and LOWER transforms.

In the Filter expression dialog:

  • filter for all-lower-case values
    "<field_name>" = LOWER("<field_name>")
  • filter for all-upper-case values
    "<field_name>" = UPPER("<field_name>")
  • filter for mixed-case values
    "<field_name>" NOT IN ( LOWER("<field_name>"), UPPER("<field_name>") )
  • Mixed means Both Upper and lower cases i.e. (Mohan METRO, Mohan metro). But it is filtering all the data which exclueds full upper and full lower cases
    – Bruno B
    Jan 19 at 10:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.