Select node with specific value

Question

I was given a web service that I have to use to pull data into a table. Right now it pulls all nodes, but I would like to pull only the nodes with Web.

Searching the web, I can only find examples of how to do this if there is an attribute, which there is not. This is what I have so far, and can't seem to figure out what to do next -

XmlNodeList records = root.SelectNodes("descendant::record[//@Origin=Web]");

Also tried -

XmlNodeList records = xmldoc.SelectNodes("/Results/Record/Origin['=Web']");

Edit - I'm aware that neither of the above attempts are even remotely close to working

Edit 2 - XML is set up like this -

<results>
  <record>
    <name></name>
    <email></email>
    <origin></origin>
  </record>
</results>

Marcel N. · Accepted Answer · 2014-07-28 15:52:00Z

4

You can do it with this XPath:

//origin[text()="web"]

It means select all origin elements (regardless of hierarchy) where the inner text is web.

So, your statement becomes now:

XmlNodeList records = xmldoc.SelectNodes("//origin[text()='web']");

edited Jul 28, 2014 at 15:52

answered Jul 28, 2014 at 15:39

Marcel N.

14k5 gold badges50 silver badges74 bronze badges

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

23 Comments

user3869708 Over a year ago

Which of the above examples should I use this with?

user3869708 Over a year ago

Unfortunately that's exactly what I had, and it's not working for some reason. Not sure if this makes a difference, but I looking at the web service, it shows the origin like this - <origin><![CDATA[Web]]></origin> Would this change the answer?

Marcel N. Over a year ago

@user3869708: OK, so the actual problem is that you have no origin elements that contain web?

user3869708 Over a year ago

Apparently not, I now see that it is displayed as <![CDATA[Web]]>

user3869708 Over a year ago

is there a different route to take?

|

Collectives™ on Stack Overflow

Select node with specific value

1 Answer 1

23 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

23 Comments

Your Answer

Sign up or log in

Post as a guest

Related