Ignore case in "compare" function? - InfoPath Dev
in

InfoPath Dev

Ignore case in "compare" function?

Last post 02-24-2012 03:58 PM by Jimmy. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 02-22-2012 07:36 AM

    Ignore case in "compare" function?

    I created a search box to search my secondary data source.  I'm displaying my 2ds table in my form.  I want hide rows if a field in my table contains the search field.  However, it seems to be case sensitive when I test it.  Is there a way around that?

    It seems that I need to somehow get this -  translate(my:field1, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz") = translate(my:field2, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")

    Combined with this - not(contains(d:Item, xdXDocument:get-DOM()/my:myFields/my:GearSearch))

  • 02-23-2012 12:54 PM In reply to

    Re: Ignore case in "compare" function?

    Suggestions?

  • 02-24-2012 03:58 PM In reply to

    Re: Ignore case in "compare" function?

    Have you tried this:

    not(contains(translate(d:Item, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz"), translate(xdXDocument:get-DOM()/my:myFields/my:GearSearch, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz")))

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.