Replace multiple instances of code in .xml file

i have xml data export 1 of our systems has individual records in 125 different groupings. each group has own header tags. need keep header first group , remove headers subsequent 124 groups while keeping of individual records each group. result in of individual records being included in first group. i can manually finding closing instance of each header, "</plan>", , deleting point through closing of header form, "</form>".  an example of code removing below:

...</plan><plan planname="xyz company plan" formyear="2016"><form formtype="common" formname=""><formdata fieldname="payername1">xyz company</formdata><formdata fieldname="payername2">plan</formdata><formdata fieldname="payeraddress">123 main st</formdata><formdata fieldname="payercity">any city</formdata><formdata fieldname="ein">999999999</formdata><formdata fieldname="payerprovinceusstate">ny</formdata><formdata fieldname="payerpostalcode">10010</formdata><formdata fieldname="payeraddress2"></formdata></form>...

the code needs removed occurs 124 times in file. when use script below, finds first instance of "</plan>" , removes there through last instance of "</form>", removes of individual records in between. here script:

get-content filename.xml | foreach-object { $_ -replace '</plan>.*</form>','' } | set-content filename2.xml

is there way loop through file, find each set of code, remove code, , move on next group header? need wildcard because header data unique each group.

thanks much!

you can load xml file this:

[xml]$xml = get-content <xml file name>

you can extract/search nodes xpath.

$nodes = $xml.selectnodes(<xpath query find required nodes>)

the nodes can edited xml methods on teh xml object.

---

\_(ツ)_/

Windows Server  >  Windows PowerShell