case-insensitive matching in xpath?

xml xpath
Ethan picture Ethan · May 23, 2010 · Viewed 108.6k times · Source

For example, for the xml below

<CATALOG>
    <CD title="Empire Burlesque"/>
    <CD title="empire burlesque"/>
    <CD title="EMPIRE BURLESQUE"/>
    <CD title="EmPiRe BuRLeSQuE"/>
    <CD title="Others"/>
<CATALOG>

How to match the first 4 records with xpath like //CD[@title='empire burlesque']. Is there xpath function to do this? Other solutions like PHP function are also accepted.

Answer

Matthew Flaschen picture Matthew Flaschen · May 23, 2010

XPath 2 has a lower-case (and upper-case) string function. That's not quite the same as case-insensitive, but hopefully it will be close enough:

//CD[lower-case(@title)='empire burlesque']

If you are using XPath 1, there is a hack using translate.

Related questions

How to use XPath contains() here?

I'm trying to learn XPath. I looked at the other contains() examples around here, but nothing that uses an AND operator. I can't get this to work: //ul[@class='featureList' and contains(li, 'Model')] On: ... <ul class="featureList"> &…

Read More
Select values from XML field in SQL Server 2008

Just looking at my XML field, my rows look like this: <person><firstName>Jon</firstName><lastName>Johnson</lastName></person> <person><firstName>Kathy</firstName&…

Read More
Extract value of attribute node via XPath

How can I extract the value of an attribute node via XPath? A sample XML file is: <parents name='Parents'> <Parent id='1' name='Parent_1'> <Children name='Children'> <child name='Child_2…

Read More