XPath lower-case() function

Question

I'm using XPATH to select certain nodes from an XML document.

The user is able to insert a value for the location. It's working fine, but it does not work if different cases are used.

I've decided that changing both the XML values and the user's input to lower case before being compared is probably the best way to go about it.

I've got this as my selector at the moment:

NodeIter = nav.Select("/Houses/House/location[contains(../location, '" + location_input + "')]");

I've tried putting the lower-case() function in various locations, but it isn't happy with it.

How do I make it so that the value of ../location is compared as lower case?

Note: location_input is set to lower using ToLower() within my c# code.

What do you mean by "it isn't happy with it"?

BoltClock
– BoltClock

2012-01-23 18:34:32 +00:00
Commented Jan 23, 2012 at 18:34 — BoltClock
– BoltClock, Commented Jan 23, 2012 at 18:34

Frédéric Hamidi · Accepted Answer · 2012-01-23 18:31:43Z

20

The lower-case() function is only supported from XPath 2.0 onwards. If your environment supports this version of the standard, you can write:

NodeIter = nav.Select("/Houses/House/location[contains(lower-case(.), '"
    + location_input + "')]");

However, chances are you're stuck with XPath 1.0. In that case, you can abuse the translate() function:

NodeIter = nav.Select("/Houses/House/location[contains(translate(., "
    + "'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz'), '"
    + location_input + "')]");

answered Jan 23, 2012 at 18:31

Frédéric Hamidi

264k42 gold badges497 silver badges486 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rashack · Accepted Answer · 2018-02-02 08:41:39Z

5

translate(../location, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') if you can get away with just A-Z

edited Feb 2, 2018 at 8:41

Rashack

4,6852 gold badges29 silver badges34 bronze badges

answered Jan 23, 2012 at 18:28

David Knight

7616 silver badges12 bronze badges

Comments

Martin Honnen · Accepted Answer · 2012-01-23 18:30:49Z

2

lower-case http://www.w3.org/TR/xpath-functions/#func-lower-case is part of XPath 2.0 and XQuery 1.0 so you need to use an XPath 2.0 or XQuery 1.0 implementation like XQSharp or like the .NET version of Saxon 9 if you want to use such functions.

With XPath 1.0 all you can do is NodeIter = nav.Select(string.Format("/Houses/House/location[contains(translate(., 'ABCDEFGHIJKLMNOPQRSTUVWXZY', 'abcdefghijklmnopqrstuvwxyz'), '{0}')]", location_input));.

answered Jan 23, 2012 at 18:30

Martin Honnen

169k6 gold badges100 silver badges122 bronze badges

Comments

Michael Kay · Accepted Answer · 2012-01-23 21:42:25Z

2

Note that strictly speaking, translating two strings to lower (or upper) case is not a correct way to do a case-blind comparison, because the mapping of lower-case to upper-case characters in Unicode is not one-to-one. In principle, in XPath 2.0 you should use a case-blind collation. Unfortunately though, although many XSLT 2.0 and XQuery 1.0 processors allow you to use a case-blind collation, there are no standards for collation URIs, so your code becomes processor-dependent.

answered Jan 23, 2012 at 21:42

Michael Kay

165k11 gold badges97 silver badges173 bronze badges

Comments

Rolf · Accepted Answer · 2016-02-04 13:12:21Z

0

As long as you are dealing with .net, you can use a Microsoft extension to do a case-insensitive comparison: ms:string-compare

https://msdn.microsoft.com/en-us/library/ms256114(v=vs.120).aspx

answered Feb 4, 2016 at 13:12

Rolf

1,0049 silver badges17 bronze badges

Comments

El Bayames · Accepted Answer · 2018-03-02 13:38:04Z

0

I had same dilemma using VS2017(NetFramework 4.6.1) and installed the XPath2 NuGet package. So far it has been worked fine for me when using XPath2 functions.

answered Mar 2, 2018 at 13:38

El Bayames

6158 silver badges14 bronze badges

Collectives™ on Stack Overflow

XPath lower-case() function

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related