How to fetch an attribute value from xml using powershell?

Question

I have a list of XML files, from which I have to get the string after a particular line.

In the files, I need to look for a tag Event and get the attribute value DLLRoutine. e.g. the tag would look something like below ...

<Event Definition="Validate" DLLPath="" DLLName="Helper.dll" DLLClass="HelpMain" 
       DLLRoutine="pgFeatureInfoOnValidate_WriteToRegSelectedFeatures" 
       InputParameters="pTreeViewFeatureTreeServerOS" RunOnce="no"/>

I just need to get Dllroutine values. How to do it using PowerShell?

score 49 · Accepted Answer · answered Aug 31 '12 at 10:18

Assuming your XML structure is something similar to:

$xml = [xml]'
<Events>
<Event Definition="Validate" DLLPath="" DLLName="Helper.dll" DLLClass="HelpMain" DLLRoutine="pgFeatureInfoOnValidate_WriteToRegSelectedFeatures" InputParameters="pTreeViewFeatureTreeServerOS" RunOnce="no"/>
<Event Definition="Validate1" DLLPath="" DLLName="Helper.dll1" DLLClass="HelpMain1" DLLRoutine="pgFeatureInfoOnValidate_WriteToRegSelectedFeatures" InputParameters="pTreeViewFeatureTreeServerOS" RunOnce="no"/>
</Events>
'

#Or get it from a XML file
$xml = [xml](Get-Content $XMLPath)

$xml.Events.Event | Select DLLName

score 21 · Answer 2 · answered Sep 30 '13 at 14:39

21

Assuming your Event element has an Events element root:

$xml.Events.Event.DLLName

I've only tested this in Powershell 3

answered Sep 30 '13 at 14:39

WhiteKnight

4,938
5
37
41

score 19 · Answer 3 · answered Sep 01 '12 at 07:24

19

you can use also xpath instead of dot notation:

$xml.SelectNodes('//Events/Event') | select DLLName

answered Sep 01 '12 at 07:24

walid2mi

2,704
15
15

2

This approach worked really good when trying to parse nodes with special characters on the name. – vhugo Oct 18 '19 at 16:13

score 8 · Answer 4 · edited Aug 29 '19 at 22:50

You could use Select-XML:

$xml = [xml]'
<Events>
<Event Definition="Validate" DLLPath="" DLLName="Helper.dll" DLLClass="HelpMain" DLLRoutine="pgFeatureInfoOnValidate_WriteToRegSelectedFeatures" InputParameters="pTreeViewFeatureTreeServerOS" RunOnce="no"/>
<Event Definition="Validate1" DLLPath="" DLLName="Helper.dll1" DLLClass="HelpMain1" DLLRoutine="pgFeatureInfoOnValidate_WriteToRegSelectedFeatures" InputParameters="pTreeViewFeatureTreeServerOS" RunOnce="no"/>
</Events>
'

Select-XML -xml $xml -xpath "//Event/@DLLName"

score 3 · Answer 5 · edited Apr 18 '14 at 15:51

3

Try $xml.Events.Event.DLLName

It will work in version 2, I have tried to use xpath in several scripts and it fails every time so until I tried the dot notation I thought I was doing it wrong.

edited Apr 18 '14 at 15:51

Palpatim

9,074
35
43

answered Apr 18 '14 at 15:23

Brian

31
1

How to fetch an attribute value from xml using powershell?

5 Answers5

Linked

Related