Newbie Questions

Re: Ignore case in text field comparison ?

Greg Collins — Fri, 15 Jun 2007 22:01:39 GMT

The safest way is to do it in code, as that can handle extended (foreign) characters. However, if you have those, you can also add them to the string in the translate() function.

Re: Ignore case in text field comparison ?

Catharine — Fri, 15 Jun 2007 13:24:40 GMT

Thank you - I had never used the translate function before

Re: Ignore case in text field comparison ?

Greg Collins — Thu, 14 Jun 2007 17:12:11 GMT

If you are comparing in code, you should already know how to due this by converting both strings to lowercase.

In rules, you can do the samething with the XPath translate() function:

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

Ignore case in text field comparison ?

Catharine — Thu, 14 Jun 2007 15:35:57 GMT

Hi, I want to compare the values in 2 different fields in conditional formatting. But they are both text fields and I want to ignore the case of the fields ie

YES=yes=Yes......etc. Is this possible or do I have to resort to code

Thanks