Select node with attribute case insensitive via XPath

Question

I would like to search node via Xpath case insensitve.

<Validation>
    <Presentation>
        <Slide Tag= "Test">
            <FontSize Value = "36"/>
        </Slide>
    </Presentation>
</Validation>

I've used this code

String xPath = string.Format("/Validation/Presentation/Slide[lower-case(@Tag)='{0}'][1]", "test");
XmlNode node = doc.DocumentElement.SelectSingleNode(xPath);

but it throws an XPath Exceptions: Namespace Manager or XsltContext needed. This query has a prefix, variable, or user-defined function. Where did I go wrong?

When you used XPath :). But seriously, is there a reason not to use XDocument here? — Jonesopolis
– Jonesopolis, Commented May 29, 2015 at 13:03
Your answer is here Getting attribute using XPath stackoverflow.com/questions/4531995/… — bilal
– bilal, Commented May 29, 2015 at 13:16

Steve Wellens · Accepted Answer · 2015-05-29 13:34:21Z

10

.NET doesn't support XPath 2.0.

So you can use this abomination:

    /Validation/Presentation/Slide[translate(@Tag,
   'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 
   'abcdefghijklmnopqrstuvwxyz')= 'test']

(I hard coded your value in for ease of testing with XPathBuilder.)

answered May 29, 2015 at 13:34

Steve Wellens

20.6k2 gold badges31 silver badges70 bronze badges

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

Comments

Joel · Accepted Answer · 2015-05-29 14:36:59Z

6

Have you tried this?
INFO: Use XPath to Perform a Case-Insensitive Search with MSXML: https://support.microsoft.com/en-us/kb/315719

use translate

doc.DocumentElement.selectSingleNode("/Validation/Presentation/Slide[translate(@Tag, 'ABCDEFGHIJKLMNOPQRSTUVWXYZ', 'abcdefghijklmnopqrstuvwxyz') = 'test']")

edited May 29, 2015 at 14:36

Joel

7,5894 gold badges56 silver badges61 bronze badges

answered May 29, 2015 at 13:15

Liu

9827 silver badges21 bronze badges

Comments

Andrey Korneyev · Accepted Answer · 2015-05-29 13:32:30Z

5

lower-case is XPath 2.0 function and .NET itself supports only Xpath 1.0 expressions, so you can't use it this way.

Alternatively you can use Linq2Xml:

var doc = XDocument.Load(@"your_file_Name");
var node = doc.XPathSelectElements("/Validation/Presentation/Slide")
               .FirstOrDefault(x => x.Attribute("Tag") != null 
                                    && String.Equals(x.Attribute("Tag").Value, "test",
                                                 StringComparison.CurrentCultureIgnoreCase));

answered May 29, 2015 at 13:32

Andrey Korneyev

26.9k16 gold badges73 silver badges72 bronze badges

Collectives™ on Stack Overflow

Select node with attribute case insensitive via XPath

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related