This is a public Forum  publicRSS

Topic

    Ineke Clewer
    Case sensitive report filtering
    Topic posted April 21, 2017 by Ineke ClewerApprentice 
    38 Views, 1 Comment
    Title:
    Case sensitive report filtering
    Content:

    I've been asked to identify contacts with initials in the first name field by returning any that don't have lower case letters in them.

    I have no idea how to identify upper and lower case in reports, the filters don't seem to be case sensitive - does anyone know a way of doing this?

    Answer

     

    • Mark Kehoe

      Hi there,

      I've had a couple of attempts at converting the text string into something else to compare it but alas nothing comes to fruition. We would need to convert the upper case and lower case string into ASCII values and then compare them but without a customisation in the report it's not possible. Might I suggest exporting it to Excel where it would be a simple task?

      Mark