General

Re: UCASE and LCASE

Coita Thierry — Wed, 22 Jun 2005 07:29:36 GMT

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

Re: UCASE and LCASE

Shanthi Reddy — Sun, 12 Jun 2005 10:17:24 GMT

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

Re: UCASE and LCASE

BrownR — Tue, 07 Jun 2005 20:03:44 GMT

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?

Re: UCASE and LCASE

Patrick Halstead — Fri, 19 Nov 2004 10:32:15 GMT

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

Re: UCASE and LCASE

jonbrave — Fri, 12 Nov 2004 09:33:25 GMT

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... :)

Re: UCASE and LCASE

sakieboy — Thu, 11 Nov 2004 22:20:07 GMT

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.

Re: UCASE and LCASE

jonbrave — Thu, 11 Nov 2004 13:42:46 GMT

This can be done with XPath "translate" function.

UCASE and LCASE

sakieboy — Thu, 11 Nov 2004 13:35:49 GMT

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