Powershell XML Node-Name with "-"

Question

0.00/5 (No votes)

See more:

Hi,

how can I read and automated processing of XML nodes with a "-" in the name with PowerShell.

I found this in the help for select-xml:

XML

<?xml version="1.0" encoding="utf-8"?>
 <Book>
   <projects>
     <project name="Book1" date="2009-01-20">
       <book-editions>
          <edition language="English">En.Book1.com</edition>
          <edition language="German">Ge.Book1.Com</edition>
          <edition language="French">Fr.Book1.com</edition>
          <edition language="Polish">Pl.Book1.com</edition>
       </book-editions>
     </project>
   </projects>
 </Book>

and added "book-" in the nodes because I have the "-" in my real xml.

the help says that if I executed this command

$xml | select-xml -xpath "//edition"

I should get this output

Text            Node          Path
----            ----          ----
En.Book1.com    edition       InputStream
Ge.Book1.Com    edition       InputStream
Fr.Book1.com    edition       InputStream
Pl.Book1.com    edition       InputStream

but I just get this

Node                                    Path                                    Pattern
----                                    ----                                    -------
edition                                 InputStream                             //edition
edition                                 InputStream                             //edition
edition                                 InputStream                             //edition
edition                                 InputStream                             //edition

So I don't know if the problem is the "-". The real question should be: How can I search for a specific node ("edition") and display/get its contend?

Thanks for your answers.

Alex

Posted 1-Sep-12 6:06am

Member 9398890

Updated 2-Sep-12 0:39am

v3

Add a Solution

Comments

Andreas Gieriet 1-Sep-12 15:00pm

What did you try and where did you fail?
Cheers
Andi
PS: Please provide the script that causes problems and some sample data, and what you exactly mean be "automated processing". Or do you expect us to invent all of that?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Zoltán Zörgő** · Answer 1 · 2012-09-02T09:44:00

I suppose, you don't need the path and the node name. So you can use one of these, supposing, that $books contains the xml:

$books | select-xml -xpath "//edition" | % {$_.Node."#text"}

$books.SelectNodes("//edition") | % { $_."#text"}

$books.book.projects.project."book-editions".edition | % {$_."#text"}

In the later one, you can see, how you could reference the element name containing the hyphen.

gjdfklfgdgfdgfdgfd · Answer 2 · 2012-09-02T10:17:00

Similar to Zoltan's solution, but displays all three columns with headings, as required:

XML

$xml = @"
<?xml version="1.0" encoding="utf-8"?>
 <Book>
   <projects>
     <project name="Book1" date="2009-01-20">
       <book-editions>
          <edition language="English">En.Book1.com</edition>
          <edition language="German">Ge.Book1.Com</edition>
          <edition language="French">Fr.Book1.com</edition>
          <edition language="Polish">Pl.Book1.com</edition>
       </book-editions>
     </project>
   </projects>
 </Book>
"@

$xml | select-xml -xpath "//edition" | select-object @{n='Text' ; e={$_.Node."#text"}}, Node, Path

Member 13351143 · Answer 3 · 2017-08-07T22:45:00

Solution 3

the below will fetch you the results

project."book-editions"

Posted 7-Aug-17 22:45pm

Member 13351143

Updated 7-Aug-17 23:12pm

v2

Comments

Kats2512 8-Aug-17 9:11am

you think after 5 years this guy would still be looking for an answer???

Member 13351143 14-Aug-18 6:00am

LOL..

Powershell XML Node-Name with "-"

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0