How to parse xml in powershell

Question

I have an xml like this:

<?xml version="1.0" encoding="utf-16"?>
<Node1 xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Item Name="1" Value="value1" />
  <Item Name="2" Value="value2" />
</Node2>

I need to get both the name and value of the "Item"s inside the "Node1" node. I am trying the following and it doesn't seem to be working ($xml contains the above string):

Write-Host $xml.ChildNodes.Node1.ToString()

Any ideas on how I can do this? Thanks.

FYI, your XML can't be parsed, as you have <Node1>...</Node2>. Change the </Node2> to </Node1>. — Matt
– Matt, Commented Jan 4, 2017 at 2:00

Ranadip Dutta · Accepted Answer · 2017-01-04 03:00:20Z

2

You can use the data type [XML] directly and with that you can parse, But it has to be a proper XML. Yours might need a little modification in the nodes. So that you can parse it using Dot :

Example:

$doc = [xml]
@'
<xml>
<Section name="Music">
<Song ="Love you" Status="1" />
<Song="Heartbeat" Status="1" />
<Song="Love to see you cry" Status="1" />
</Section>
</xml>
'@

Screenshot is for reference.

Hope it helps.

answered Jan 4, 2017 at 3:00

Ranadip Dutta

9,5493 gold badges33 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

How to parse xml in powershell

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related