Classic ASP and XML - Selecting a specific node

Hi, I' need to select a specific node in an xml doc... i have this which gives me everything

For Each xmlNode In objXML.documentElement.selectNodes("Data")

but i need a single node and its related nodes that has a specific value.. please see the xml

for example: I need to select only the Data where Bookcode = NEA-CSOP

Thank you

<DocumentElement>
<Data>
  <BookCode>NEA-CSOP</BookCode>
  <BPSday>3</BPSday>
  <BPSwk>6</BPSwk>
  <BPSmth>8</BPSmth>
  <Trackday>-44.6</Trackday>
  <TrackPnL>0</TrackPnL>
  <WAIVImv>0.239</WAIVImv>
  <WAIVexp>0.252</WAIVexp>
  <x90Day>0.256</x90Day>
</Data>

<Data>
<BookCode>NEA-EA1</BookCode>
<BPSday>18</BPSday>
<BPSwk>39</BPSwk>
<BPSmth>44</BPSmth>
<Trackday>-23.5</Trackday>
<TrackPnL>0</TrackPnL>
<WAIVImv>0.219</WAIVImv>
<WAIVexp>0.217</WAIVexp>
<x90Day>0.256</x90Day>
</Data>

<Data>
<BookCode>NEK-MV4</BookCode>
<BPSday></BPSday>
<BPSwk></BPSwk>
<BPSmth></BPSmth>
<Trackday></Trackday>
<TrackPnL></TrackPnL>
<WAIVImv></WAIVImv>
<WAIVexp></WAIVexp>
<x90Day></x90Day>
</Data>
<DocumentElement>

Open in new window

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

LVL 8

Flabio GatesCommented: 2017-11-09

Can you try:

For Each xmlNode In objXML.documentElement.selectNodes("Data[text()='NEA-CSOP']")

nthawkins1971Author Commented: 2017-11-09

Doesn't seem to work, however it doesnt cause an error.. should I add BookCode in some way... like, Data.BookCode[text()='NEA-CSOP' ?

For Each xmlNode In objXML.documentElement.selectNodes("Data[text()='NEA-CSOP']")

Data/BookCode[text()='NEA-CSOP']

But that would get you the BookCode node.
You'll need to get back up 1 level to the Data node.
Not sure as I'm on my phone but it would look like
Data/BookCode[text()='NEA-CSOP']/parent-node::*

LVL 57

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented: 2017-11-09

try this instead.

Data[BookCode/text()='NEA-CSOP']

Absolutely perfect! thanks

was almost there:

Data/BookCode[text()='NEA-CSOP']/parent::*

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented: 2017-11-13

well, absolutely perfect but yet not accepted as answer?

Classic ASP and XML - Selecting a specific node

Who is Participating?