How to extract specific value from XML using XPath

Question

I need to extract values of elements: price and publisher, given the title of the book from this XML.

<book>
    <title>Burning Tower</title>
    <author>Larry Niven</author>
    <author>Jerry Pournelle</author>
    <publisher>Pocket</publisher>
    <isbn>0743416910</isbn>
    <price>5.99</price>
</book>

How this can be done?

I need to extract attribute name when field name is given. Suppose if I have field name Testing, then I need to extract attribute value for name corresponding to that field.

<RequirementFieldList>
  <field name="SN_Name">Testing</field>
  <field name="Email1">Test1_User</field>
  <field name="Email2">na</field>
  <field name="Email3">na</field>
  <field name="Email4">na</field>
</RequirementFieldList>

price is inside title or book?

Shubham Jain
– Shubham Jain

2019-10-25 07:46:55 +00:00
Commented Oct 25, 2019 at 7:46 — Shubham Jain
– Shubham Jain, Commented Oct 25, 2019 at 7:46

MoonMist · Accepted Answer · 2019-10-25 08:16:46Z

1

Using the XPath: book[title='foo']/price will give you the price values of all books with the title "foo". To get the publisher you can just use: book[title='foo']/publisher.

This provides a similar example to yours: https://www.w3schools.com/xml/xml_xpath.asp

answered Oct 25, 2019 at 8:16

MoonMist

1,2848 silver badges24 bronze badges

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

2 Comments

Anchal Sarraf Over a year ago

Thank You so much. Please provide answer of 2nd question which I have added in this question too.

MoonMist Over a year ago

@AnchalSarraf For your second question, simply RequirementFieldList/field[text()="Testing"]/@name

Collectives™ on Stack Overflow

How to extract specific value from XML using XPath

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related