InfoPath Dev

Would like to see this as an option in the functions, so that I won't have to write code for this.

This can be done with XPath "translate" function.

isn't translate the same thing as replace? As pertaining to my issue, I won't need it because I was actually attempting to compare a node to a String within the code, found another way to do this.

Kind of :)

translate(source, 'ABC...', 'abc...')
[yes, you have to type in every letter!] does LCASE. Each char is replaced/translated from it postion (i.e. index) found in 'ABC...' to the same position in 'abc...'. Rudimentary, but that's all XPath offers natively.

This all goes back to 'tr' in Perl/SED from UNIX days... :)

Note: this translate is useful if you are doing filtering and you want to do a case insensitive filter on a text value.

Interesting that i find this. Im trying to compair the username (whos logged in) to a data field. The names in the datafeild are all in lowercase but of course anybody can log in with upper and lowercase if they like. If i compair the two and they're not both in lower case it doesnt see the name on the list. How can i use "Translate" to solve this?

Hello BrownR,
You can solve this by doing a translate on the two value so that both of them are in the same case and them compare them. Something like this will be part of your xpath.
translate(Customer/LastName,'QWERTYUIOPLKJHGFDSAZXCVBNM','qwertyuioplkjhgfdsazxcvbnm') = translate(\"{1}\", 'QWERTYUIOPLKJHGFDSAZXCVBNM','qwertyuioplkjhgfdsazxcvbnm')

Shanthi
InfoPathDev India

Hi,

You have an XPATH function for do that:

upper-case(string) Converts the string argument to upper-case
Example: upper-case('The XML')
Result: 'THE XML'

lower-case(string) Converts the string argument to lower-case
Example: lower-case('The XML')
Result: 'the xml'


++

Thierry


Every moment hesitated is a moment gone for life!!! Think about it