How to use Powershell to enumerate attributes of an XML element

Question

I have an XML file that is structured like this:

<XMLFile>
    <Thing Stuff1='data' Stuff2='data' Stuff3='data' .....Stuff100='data'</Thing>
    <Thing Stuff1='data' Stuff2='data' Stuff3='data' .....Stuff85='data'</Thing>
    <Thing Stuff1='data' Stuff2='data' Stuff3='data' .....Stuff91='data'</Thing>
    .
    .
    .
</XMLFile>

The attributes in each Thing are not always the same, some may be present and some may not. I read the file into $xmldata like this:

[xml]$xmldata = Get-Content -Path xmlfilename

I access each 'Thing' in $xmldata like this:

$xmldata.XMLFile.Thing

I want to enumerate all the Stuff attributes using something like

$xmldata.XMLFile.Thing.ForEach({$_.??????})

What do I use in place of the question marks to get a list of all the 'Stuff' items in each 'Thing'?

mklement0 · Accepted Answer · 2021-11-05 23:01:08Z

4

# Parse the XML file into a DOM.
[xml] $xmldata = Get-Content -Raw -LiteralPath xmlfilename

# Loop over the 'Thing' elements' attributes and emit them as 
# custom objects with names and values.
$xmlData.XMLFile.Thing.Attributes.ForEach({ 
  [pscustomobject] @{ Name = $_.Name; Value = $_.Value }
})

Note the use of -Raw to speed up parsing the input file into an XML DOM. However, the robust way to parse an XML file that avoids character-encoding pitfalls requires the technique described in the bottom section of this answer.

edited Nov 5, 2021 at 23:01

answered Nov 5, 2021 at 22:55

mklement0

452k68 gold badges728 silver badges987 bronze badges

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

3 Comments

dstroupe Over a year ago

I knew Attributes had to be there somewhere, I just was putting it into the ForEach. Beautiful, Thanks for the -RAW info as well. Thank you!!!

Abraham Zinala Over a year ago

What is a DOM.?

mklement0 Over a year ago

@AbrahamZinala, it is short for Document Object Model

Collectives™ on Stack Overflow

How to use Powershell to enumerate attributes of an XML element

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related