Ignoring Case Sensitivity on filtering data - InfoPath Dev
in

InfoPath Dev

Ignoring Case Sensitivity on filtering data

Last post 07-30-2009 11:47 AM by vivasuzi. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next

  • 05-12-2009 09:29 AM

    • lou131
    • Top 100 Contributor
    • Joined on 02-13-2007
    • USA
    • Posts 89

    Ignoring Case Sensitivity on filtering data

    Reply Contact

    Hi,

    Is there way to ignore case sesitivity when filtering on data?

    Thanks
    Lou

  • 05-12-2009 10:52 PM In reply to

    Re: Ignoring Case Sensitivity on filtering data

    Mark as Not Answer
    Reply Contact

    It's not very pretty, but you can perform a non-case sensitive comparison by converting both sides of the comparison (or one side if the other is a constant) to lower case.

     So if I wanted the filter to include rows where field1 = field2 (ignore case), I could use the formula

    translate(my:field1, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = translate(my:field2, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

     That translate() function mess is the magic that returns the lower-case version of a string value.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 07-30-2009 11:47 AM In reply to

    Re: Ignoring Case Sensitivity on filtering data

    Mark as Answer
    Reply Contact
    It may be messy but it works!  Thanks!!!
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.