Parsing XML Files with PowerShell

Question

To give an idea of how the XML code looks like that I am working with here.

<content>
<text id="new-users">
<Chinese>Nuevos usuarios</Chinese>
<English>New Users</English>
</text>
<text id="create-an-account">
<Chinese>Crear una Cuenta</Chinese>
<English>Create an Account</English>
</text>

I want to pull All of the English text between the < English > the test< /English > and have it listed then add a comma to the end. to export it to excel.

I can't understand what powershell is doing I am kind of lost. I can get "text" to print out a lot of times and I looked in to printing out the get-contents then piping the contents with a sort to only print the English and it didn't work.

Can you show us what PowerShell script you've written so far? — MrKWatkins
– MrKWatkins, Commented Aug 17, 2011 at 15:16

EBGreen · Accepted Answer · 2011-08-17 15:42:54Z

4

So there are a couple of ways to get to the data. Here is the XPath way:

[xml]$x = Get-Content C:\Path\To\File.xml
$x.SelectNodes('//text/English') | Export-CSV C:\Path\To\Result.csv -NoTypeInfo

answered Aug 17, 2011 at 15:42

EBGreen

38k12 gold badges69 silver badges86 bronze badges

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

2 Comments

manojlds Over a year ago

Isn't $x.SelectNodes("//English") enough?

EBGreen Over a year ago

Probably, I just tend to be more explicit out of habit.

manojlds · Accepted Answer · 2011-08-17 17:02:42Z

1

One way would be:

[xml] $xml = gc file.xml
$xml.content.text | select English | Export-CSV test.csv -notype

answered Aug 17, 2011 at 17:02

manojlds

303k66 gold badges482 silver badges426 bronze badges

2 Comments

EBGreen Over a year ago

I think you probably meant this comment to be on my answer, but you are probably right that it would be sufficient.

manojlds Over a year ago

@EBGreen - lol, sorry didn't even realize that I had commented on my own answer :)

Collectives™ on Stack Overflow

Parsing XML Files with PowerShell

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related