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.sel
ectNodes("
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>
Select all Open in new window
Open in new window