Powershell Xml query

Question

Here is exam XML..

<?xml version="1.0" encoding="UTF-8"?>
<books>
    <book>
        <title>a book</title>
        <writer>Tom</writer>
    </book> 
    <book>
        <title>b book</title>
        <writer>John</writer>
    </book> 
    <book>
        <title>c book</title>
        <writer>Tom</writer>
    </book> 
</books>

I want to find a list of this writer is Tom. So my script is

[xml]$books = Get-Content C:\Users\Administrator\Documents\books.xml
$books.book| %{$_.book.writer -match 'Tom'}

But this script show only writer...

writer
Tom
Tom

I want to see like this

title      writer
a book     Tom
c book     Tom

help me plz.

Joey · Accepted Answer · 2013-08-30 08:15:57Z

2

You probably want to use ? , a.k.a. Where-Object instead of %:

$books.book| ?{$_.book.writer -match 'Tom'}

This is a filter on the previous pipeline element, restricting what comes out of it, while with ForEach-Object you're projecting, i.e. creating a new sequence of objects.

Your code and output don't make sense, though. First of all, $books shouldn't have a book property but instead books. You should have seen

True
False
True

instead of writer objects, unless there are multiple writer elements per book.

edited Aug 30, 2013 at 8:15

answered Aug 30, 2013 at 7:41

Joey

357k88 gold badges704 silver badges699 bronze badges

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

Comments

Alexan · Accepted Answer · 2017-05-28 17:16:41Z

1

I meant to write

select-xml -Path C:\XML\doc2.txt -XPath "//book[writer='Tom']//ancestor::book"

title writer

a book Tom c book Tom

Ernest Brant

edited May 28, 2017 at 17:16

Alexan

8,71514 gold badges83 silver badges107 bronze badges

answered May 28, 2017 at 16:52

AUser

633 silver badges13 bronze badges

Comments

Jdenouel · Accepted Answer · 2015-04-04 12:50:37Z

0

With Powershell 4 just use

$books.books.book

answered Apr 4, 2015 at 12:50

Jdenouel

1

Collectives™ on Stack Overflow

Powershell Xml query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related