Case sensitive fields

[Terry]

Hello all,
I am trying to setup a form with a lookup XML table and the data I am
receiving to access the lookup can come accross as either Title Case or
UPPERCASE. Is there any way I can make fields non-case sensitive?

 

[Ben Walters]

Hey Terry,
Sorry but no the case sensitivity is inherent in the XML model. Your best
bet is to read your XML file into a staging area then update all the fields
to a standard (either upper case or title case) then connect your InfoPath
form to it.

Hope this helps

Cheers
Ben

 

[Greg Collins [InfoPath MVP]]

When you make your comparison between field values, translate each of them into just upper or lowercase.

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

 

[Terry]

Hi Greg,

We have implemented this solution.

Thanks for the help

Terry

 

[Greg Collins [InfoPath MVP]]

Glad to help!