How to extract the value of xml node to a variable in powershell?

Question

I am working to build a Power shell script that reads a XML file and extracts the values from the nodes to make further calculations. How could I extract the node values to variables?

I have written code using XMLDOC in PS to read the file and extract the values in Power shell. I am able to get the attribute value of a single node. I am not able to extract the node value which has attributes too and there are multiple occurrences of the node.

Test.xml

<abc>
  <body>
    <Rows Count="02">
      <Row>
        <a ID="1">Name1</a>
        <a ID="2">Naresh</a>
        <a ID="3">Arvind</a>
      </Row>
      <Row>
        <a ID="1">Name2</a>
        <a ID="2">Sathish</a>
        <a ID="3">Kannan</a>
      </Row>
    </Rows>
  </body>
  <abc>

Code

   [xml]$XmlDocument = Get-Content E:\Desktop\Test.xml 
   $nodes = $XmlDocument.SelectNodes('//Rows') 
   $A = $nodes.GetAttribute("count")  

   if ($A -eq '02')
    {
     $B = $XmlDocument.abc.Body.Rows.ROW.a | Where-Object {$_.ID -eq '2'}
    }

Expected Result

Variable A should get "02"(only value) and "Naresh","Sathish" (only values) should be stored in 2 different variables

Actual Result

Variable A gets "02" - it is working both "Naresh" and "Sathish" are stored in Variable B but stored with the IDs and headers.

HariHaran · Accepted Answer · 2019-03-25 13:30:23Z

3

[xml] $str = @'
<abc>
  <body>
    <Rows Count="02">
      <Row>
        <a ID="1">Name1</a>
        <a ID="2">Naresh</a>
        <a ID="3">Arvind</a>
      </Row>
      <Row>
        <a ID="1">Name2</a>
        <a ID="2">Sathish</a>
        <a ID="3">Kannan</a>
      </Row>
    </Rows>
  </body>
  </abc>
'@


$a = $str.abc.body.Rows.Row.a | Where-Object {$_.ID -eq '2'} | Select-Object -ExpandProperty '#text'

Use the Select-Object property and you will be having only Naresh & Sathish in output.

answered Mar 25, 2019 at 13:30

HariHaran

4,4592 gold badges26 silver badges39 bronze badges

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

2 Comments

Black Pearl Over a year ago

Can we extract "Naresh" and "Sathish" in two different variables? $A = Naresh $B = Sathish Could we use where-object for the first fields?

Black Pearl Over a year ago

I used an array to split the values to two variables

Collectives™ on Stack Overflow

How to extract the value of xml node to a variable in powershell?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related