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?

ravikanth · Accepted Answer · 2012-08-31 10:18:46Z

50

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

answered Aug 31, 2012 at 10:18

ravikanth

26k4 gold badges62 silver badges61 bronze badges

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

2 Comments

gluttony Over a year ago

Great, in addition, I use ` -ExpandProperty Name` to get only value, without headings: $xml.Events.Event | Select DLLName -ExpandProperty Name, found here: stackoverflow.com/a/25184592/11159476

RvdK Over a year ago

@gluttony For the select you need to specify the property only once: "| Select -ExpandProperty DLLName"

WhiteKnight · Accepted Answer · 2013-09-30 14:39:40Z

23

Assuming your Event element has an Events element root:

$xml.Events.Event.DLLName

I've only tested this in Powershell 3

answered Sep 30, 2013 at 14:39

WhiteKnight

5,1165 gold badges41 silver badges44 bronze badges

Comments

walid2mi · Accepted Answer · 2012-09-01 07:24:04Z

19

you can use also xpath instead of dot notation:

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

answered Sep 1, 2012 at 7:24

walid2mi

2,90417 silver badges15 bronze badges

1 Comment

vhugo Over a year ago

This approach worked really good when trying to parse nodes with special characters on the name.

pim · Accepted Answer · 2024-05-25 23:53:21Z

6

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").Node

edited May 25, 2024 at 23:53

answered Mar 20, 2017 at 14:17

pim

12.7k6 gold badges71 silver badges70 bronze badges

2 Comments

Pxtl Over a year ago

Did you try this? When I attempt in Powershell 5 it just returns a bunch of node and object metadata, not the actual contents.

pim Over a year ago

Yep. You are getting the results you should be. PowerShell is designed around objects. Try this to get the DLL names: (Select-XML -xml $xml -xpath "//Event/@DLLName").Node

Palpatim · Accepted Answer · 2014-04-18 15:51:40Z

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, 2014 at 15:51

Palpatim

9,30237 silver badges45 bronze badges

answered Apr 18, 2014 at 15:23

Brian

311 bronze badge

Collectives™ on Stack Overflow

How to fetch an attribute value from xml using powershell?

5 Answers 5

2 Comments

Comments

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related