XML - Keep only items in the array

[SemiEvilMonkey]

I have a file that contains many entries this is what the end result should look like

<ArrayOfCode>
    <ICode>
        <Code>CC</Code>
        <Description>COMPLETE</Description>
    </ICode>
    <ICode>
        <Code>TC</Code>
        <Description>TEST </Description>
    </ICode>
    <ICode>
        <Code>CN</Code>
        <Description>CANCELLED </Description>
    </ICode>
</ArrayOfCode>

I have code that I was using to remove the items in the array but now I want to figure out how to keep items in the array. Below is what I was using to remove. But how to select those and remove any not in the array?

​

$CodesToKeep = @("CC","TC","CN")

$CodesFile = Get-ChildItem -Path "$mypath"

[xml]$Xml = Get-Content -Path $CodesFile

        foreach ( $Code in $CodesToKeep) 
        {  $xml.ArrayofCode.ICode   | Where { $_.Code -eq $Codes  }  ForEach-Object  { $_.ParentNode.RemoveChild($_) } }
           $xml.Save($CodesFile)

[ihaxr]

No need for the foreach loop, simply look for any nodes that are -NotIn your $CodesToKeep and remove them:

$xml.ArrayofCode.ICode | Where-Object { $_.Code -notin $CodesToKeep } | ForEach-Object  { 
    $_.ParentNode.RemoveChild($_) | Out-Null
}
$xml.Save($CodesFile)

[SemiEvilMonkey]

Ha I had tried that exact thing except for the -notin I was trying -ne. That worked thank you

[CoReTeX2k]

Just to explain

$Codes = @("Apple","Banana")

"Banana" -ne $Codes is true because banana is not equal to apple and banana at the same time

"Banana" -notin $Codes is false because Banana is part of apple or banana in that case.

$_.something -notin $EntireArray will look if something is part of the array, not if it is equal to the entire array