XPath command to get only a specific element data and not others

Question

Suppose I have an XML file -

<Cars>
            <Year> 2021 </Year>
            <Model>
                <Name> Porsche 911 </Name>
                <Year> 2020 </Year>
            </Model>
            <Model>
                <Name> Porsche 911 </Name>
                <Year> 2019 </Year>
            </Model>
            <Model>
                <Name> Porsche Cayenne </Name>
                <Year> 2019 </Year>
            </Model>
</Cars>

Now I want to extract the Year 2021 which is not the Year of that particular model but the date when this XML was written (It is the outer one)

But to do that.. due to restraints on the path not being hardcoded, I was using //Year//text() but it gives out the output as [2021,2020,2019,2019]. I don't want that because if the order is changed, the index changes and that would create a problem.

Please help with a XPath command where I can exclude the inner Year tags and only use the outer one.

JaSON JaSON · Accepted Answer · 2021-03-24T12:47:34

Try this one to get only outer Year

//Year[not(preceding-sibling::Name)]/text()

If required Year node (nodes) is always direct child of Cars then

//Cars/Year/text()

should also be OK

XPath command to get only a specific element data and not others

1 Answers