Remove specific xml elements using PowerShell

Question

I have the following xml:

<NS1:PriceMaintenanceRequest xmlns:NS1="http://retalix.com/R10/services" MajorVersion="2" MinorVersion="0" FixVersion="0">
  <NS1:Header>
    <NS1:MessageId>1234</NS1:MessageId>
    <NS1:Bulk UnitOfWork="false"/>
  </NS1:Header>
  <NS1:ProductPrice BusinessUnitId="9200" Action="AddOrUpdate">
    <NS1:ProductId>2840000133</NS1:ProductId>
    <NS1:Price Action="AddUpdate" Sequence="1234">
      <NS1:UnitOfMeasureCode>EA</NS1:UnitOfMeasureCode>
      <NS1:EffectiveDateTimestamp>2012-09-20T00:00:00</NS1:EffectiveDateTimestamp>
      <NS1:EndDateTimestamp>2056-12-12T23:59:00</NS1:EndDateTimestamp>
      <NS1:CatalogPrice Currency="USD">4.2900</NS1:CatalogPrice>
      <NS1:BatchID>491364c5-73f5-45a4-8355-79cc0a720ea0</NS1:BatchID>
      <NS1:ChangeStatus>NA</NS1:ChangeStatus>
    </NS1:Price>
  </NS1:ProductPrice>
  <NS1:ProductPrice BusinessUnitId="90" Action="AddOrUpdate">
    <NS1:ProductId>2840000133</NS1:ProductId>
    <NS1:Price Action="AddUpdate" Sequence="1234">
      <NS1:UnitOfMeasureCode>EA</NS1:UnitOfMeasureCode>
      <NS1:EffectiveDateTimestamp>2012-09-20T00:00:00</NS1:EffectiveDateTimestamp>
      <NS1:EndDateTimestamp>2056-12-12T23:59:00</NS1:EndDateTimestamp>
      <NS1:CatalogPrice Currency="USD">4.2900</NS1:CatalogPrice>
      <NS1:BatchID>491364c5-73f5-45a4-8355-79cc0a720ea0</NS1:BatchID>
      <NS1:ChangeStatus>NA</NS1:ChangeStatus>
    </NS1:Price>
  </NS1:ProductPrice>
  <NS1:ProductPrice BusinessUnitId="90" Action="AddOrUpdate">
    <NS1:ProductId>2840000133</NS1:ProductId>
    <NS1:Price Action="AddUpdate" Sequence="1234">
      <NS1:UnitOfMeasureCode>EA</NS1:UnitOfMeasureCode>
      <NS1:EffectiveDateTimestamp>2012-09-20T00:00:00</NS1:EffectiveDateTimestamp>
      <NS1:EndDateTimestamp>2056-12-12T23:59:00</NS1:EndDateTimestamp>
      <NS1:CatalogPrice Currency="USD">4.2900</NS1:CatalogPrice>
      <NS1:BatchID>491364c5-73f5-45a4-8355-79cc0a720ea0</NS1:BatchID>
      <NS1:ChangeStatus>NA</NS1:ChangeStatus>
    </NS1:Price>
  </NS1:ProductPrice>
</NS1:PriceMaintenanceRequest>

I need to remove all nodes with BusinessUnitId="90". So in this example, I end up with this:

<NS1:PriceMaintenanceRequest xmlns:NS1="http://retalix.com/R10/services" MajorVersion="2" MinorVersion="0" FixVersion="0">
  <NS1:Header>
    <NS1:MessageId>1234</NS1:MessageId>
    <NS1:Bulk UnitOfWork="false"/>
  </NS1:Header>
  <NS1:ProductPrice BusinessUnitId="9200" Action="AddOrUpdate">
    <NS1:ProductId>2840000133</NS1:ProductId>
    <NS1:Price Action="AddUpdate" Sequence="1234">
      <NS1:UnitOfMeasureCode>EA</NS1:UnitOfMeasureCode>
      <NS1:EffectiveDateTimestamp>2012-09-20T00:00:00</NS1:EffectiveDateTimestamp>
      <NS1:EndDateTimestamp>2056-12-12T23:59:00</NS1:EndDateTimestamp>
      <NS1:CatalogPrice Currency="USD">4.2900</NS1:CatalogPrice>
      <NS1:BatchID>491364c5-73f5-45a4-8355-79cc0a720ea0</NS1:BatchID>
      <NS1:ChangeStatus>NA</NS1:ChangeStatus>
    </NS1:Price>
  </NS1:ProductPrice>
</NS1:PriceMaintenanceRequest>

How do i do it with PowerShell?
I need to load a files containing this xml from a directory, manipulate them, and save them.

Thanks a lot

Frode F. · Accepted Answer · 2014-04-06 16:57:16Z

2

You can do something like this:

Get-ChildItem -Path "C:\FolderWithXMLs" -Filter "*.xml" | ForEach-Object {

    $path = $_.FullName
    $xml = [xml](Get-Content $path)

    $xml.PriceMaintenanceRequest.ProductPrice | ? { $_.BusinessUnitId -eq "90" } | % { 
        #Remove node
        $xml.PriceMaintenanceRequest.RemoveChild($_)
    }

    $xml.Save($path)

}

edited Apr 6, 2014 at 16:57

answered Apr 6, 2014 at 15:57

Frode F.

55.4k9 gold badges104 silver badges118 bronze badges

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

2 Comments

Avi Shilon Over a year ago

Works great, but I forgot to to add that i need to do it for all files in a directory... sorry.

Frode F. Over a year ago

Fixed. Show some effort next time. Searching for files and running a foreach-loop is something everyone should be able to do. This isn' a webstore for powershell solutions. We actually expect you to be able to tweak it yourself.

Collectives™ on Stack Overflow

Remove specific xml elements using PowerShell

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related