how to search for a text node with a particular value in an xml document with labview

alpony01 · ‎05-28-2013

supposing i have the following xml document:
<head>

<book>

</book>

<book>

<bookname>the spear warrior</bookname>

<author>britney</author>

</book>

<book>

<bookname>the beard</bookname>

<author>derrick</author>

</book>

</head>

i want to search for the author of the book "the beard" using for example the V.I Get first match of labview to access the the node with value "the beard" and then use Get next sibling V.I and Get node text content to get get the author of this book..so my question is how do i write the xpath expression for Get first match so as to access the node with bookname "the beard" instantyly? am trying to minimise the use of loops because they increase the time duration,..thank you (NB:i dont want to use Get all Matched V.I because it obliges me to use a loop in order to access the name derrick and this increases the time duration for my v.i)

didje007 · ‎05-28-2013

I'm not really familiar with Xml queries but I had a similar situation recently and I used the following workaround.

Make bookname an attribute your XML becomes:

<head>
<book bookname="zio">
<author>dan</author>
</book>
<book bookname="the spear warrior">
<author>britney</author>
</book>
<book bookname="the beard">
<author>derrick</author>
</book>
</head>

And the query to obtain derrick is

/head/book[@bookname="the beard"]/author

camerond · ‎05-28-2013

Since it's all text, why not use a real quick Match Pattern (or Regular Expression, but you don't need that much power here), see attached.

Cameron

To err is human, but to really foul it up requires a computer.
The optimist believes we are in the best of all possible worlds - the pessimist fears this is true.
Profanity is the one language all programmers know best.
An expert is someone who has made all the possible mistakes.

To learn something about LabVIEW at no extra cost, work the online LabVIEW tutorial(s):

LabVIEW Unit 1 - Getting Started</ a>
Learn to Use LabVIEW with MyDAQ</ a>

Darin.K · ‎05-28-2013

Too lazy to remove the gratuitous . (current) which started out as .. (parent) when I misread the XML.

alpony01 · ‎05-29-2013

thank you very much sir,it works right now..i was mainly interested in the part //*[bookname='the beard']/./author and using that in my v.i it works right!! thank very much again

alpony01 · ‎05-29-2013

thank you didje..unfortunately it didn't work this way,,,but thanks all the same

alpony01 · ‎05-29-2013

thank you cameround..unfortunately that's not exactly what i wanted,,,but thanks all the same

alpony01 · ‎05-29-2013

supposing i had the string below,how will the part //*[bookname='the beard']//author modify ?in this case there is a possibility of having more than one head...please explain your reply a little bit..

<head>
<book bookname="zio">
<author>dan</author>
</book>
<book bookname="the spear warrior">
<author>britney</author>
</book>
<book bookname="the beard">
<author>derrick</author>
</book>
</head>

</project>

alpony01 · ‎05-29-2013

sorry it was me making a mistake,figured it out,thanks

LabVIEW

how to search for a text node with a particular value in an xml document with labview

how to search for a text node with a particular value in an xml document with labview

Re : how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview

Re : how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview

Re: how to search for a text node with a particular value in an xml document with labview