Remove few lines from file by means of powershell

Question

If I want to remove from document lines with some string key ("foo" for example) I use this:

$content = Get-Content 'C:/fake.txt' | Where-Object {$_ -notmatch 'foo'}
$content | Out-File 'C:/fake.txt'

But now I have file with this scheme:

...
<data name="BLABLA" xml:space="preserve">
   <value>some data here</value>
</data>
...
<data name="BLABLA22" xml:space="preserve">
   <value>some data</value>
   <comment>some comment</comment>
</data>

And I need to remove for key "BLABLA" this three lines

<data name="BLABLA" xml:space="preserve">
   <value>some data here</value>
</data>

And for key "BLABLA2" this four lines

<data name="BLABLA22" xml:space="preserve">
   <value>some data</value>
   <comment>some comment</comment>
</data>

How can I do this by means of powershell?

David Martin · Accepted Answer · 2013-09-19 21:17:15Z

4

If you want to delete the complete node, then the following should get you there.

# load the file into xml
[xml]$dom = gc file.xml

# find the node
$nod = $dom.SelectSingleNode("/root/data[@name='BLABLA']")

# remove the node from the parent
$nod.ParentNode.RemoveChild($nod)

# save the xml
$dom.save("file.xml")

I've assumed your data looks a bit like this:

<root>
    <data name="BLABLA" xml:space="preserve">
       <value>some data here</value>
    </data>
    <data name="BLABLA22" xml:space="preserve">
       <value>some data</value>
       <comment>some comment</comment>
    </data>
</root>

answered Sep 19, 2013 at 21:17

David Martin

12.4k2 gold badges67 silver badges75 bronze badges

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

Collectives™ on Stack Overflow

Remove few lines from file by means of powershell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related