How can I select specific XML nodes in Powershell from multiple node values?

Question

I have the following XML syntax and I'm trying to obtain the value in Node ID "2", Row Key "Vol2-3" for now:

<nodes>
   <node id="1">
     <store>
        <row key="Vol1-1" value="1a"/>
        <row key="Vol1-2" value="1b"/>
        <row key="Vol1-3" value="1c"/>
        <row key="Vol1-4" value="1d"/>
</store>
</node>
   <node id="2">
     <store>
        <row key="Vol2-1" value="2a"/>
        <row key="Vol2-2" value="2b"/>
        <row key="Vol2-3" value="2c"/>
        <row key="Vol2-4" value="2d"/>
</store>
</node>
   <node id="3">
     <store>
        <row key="Vol3-1" value="3a"/>
        <row key="Vol3-2" value="3b"/>
        <row key="Vol3-3" value="3c"/>
        <row key="Vol3-4" value="3d"/>
</store>
</node>
</nodes>

Code:

$nodevar=2 
[xml]$XMLDoc=(Get-Content "\..\..somefile.txt")
$value_extract=$XMLDoc.nodes.SelectNodes("node[@id='$nodevar']").store.SelectNodes("row[@key='']")

The issue I have is that I'm trying to set my $value_extract variable to pivot from the correct node ID to get to the corresponding row key containing my value. I wrote it in such a way that I'll eventually be using the SelectNodes in a for loop to obtain the values I need for further processing. Is there a good way to write this since I'm pivoting off of the correct node ID as well as the correct row key?

Palle Due · Accepted Answer · 2018-04-24 16:15:08Z

1

I'm not sure I understand your pivot-problem, but this should work, if you just need to get the text value:

[xml]$xml = Get-Content "somexml.xml"
$nodevar = "2"
$keyvar = "Vol2-3"
$value_extract=$xml.SelectNodes("/nodes/node[@id='$nodevar']/store/row[@key='$keyvar3']/@value")

answered Apr 24, 2018 at 16:15

Palle Due

6,3224 gold badges22 silver badges36 bronze badges

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

1 Comment

xorLogic Over a year ago

Hi Palle Due. I meant to say using $nodevar=2 to move from that specific node value to get to the underlying row key values. Dunno if that explains it better.

user2226112 · Accepted Answer · 2018-04-24 18:01:50Z

0

Or without using xpath syntax:

$node = $XMLDoc.nodes.node | ? id -eq '2'
$row = $node.store.row | ? key -eq 'Vol2-3'
$row.value

answered Apr 24, 2018 at 18:01

user2226112

1 Comment

xorLogic Over a year ago

Thanks Swonkie, I'll have to look into this.

Collectives™ on Stack Overflow

How can I select specific XML nodes in Powershell from multiple node values?

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related