PowerShell manipulating XML file issue

Question

Suppose I have the following XML file, and I want to use PowerShell (version 1.0) to manipulate the XML file to get the value for Foo (in this sample, value I want to get is "Foo Value") and Goo (in this sample, value I want to get is "Goo Value"), any ideas how to implement?

$FooConfig = [xml](get-content .\Foo.exe.config -ErrorAction:stop)

<configuration>
 <appSettings>
    <add key="Foo" value="Foo Value" />
    <add key="Goo" value="Goo Value" />
 </appSettings>
</configuration>

thanks in advance, George

driis · Accepted Answer · 2009-07-22 13:43:52Z

4

The XPath API is very alive under PowerShell (your XML is, after all, just .NET objects), and it can often be the easiest to use if you just want a value:

$appSettingsSection = $fooConfig.configuration.appSettings;
$goo = $appSettingsSection.SelectSingleNode("add[@key='Goo']");
$goo.Value

Or if you want to enumerate the add elements as a PowerShell collection (a bit more PowerShell'ish :-)

$appSettingsSection = $fooConfig.configuration.appSettings.add

Will print

key                                                         value
---                                                         -----
Foo                                                         Foo Value
Goo                                                         Goo Value

And of course, you can pipe that result to additional commands to do whatever processing you like.

edited Jul 22, 2009 at 13:43

answered Jul 22, 2009 at 13:37

driis

165k46 gold badges272 silver badges345 bronze badges

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

1 Comment

George2 Over a year ago

Cool, my question is answered!

Keith Hill · Accepted Answer · 2009-07-22 23:38:40Z

2

Yet annother approach using XPATH with the XML API is to use SelectNodes:

PS> $FooConfig .SelectNodes('//add')

key                                                         value
---                                                         -----
Foo                                                         Foo Value
Goo                                                         Goo Value

answered Jul 22, 2009 at 23:38

Keith Hill

1 Comment

Mark Arnott Over a year ago

Careful there! This is a config file and most config files have many 'add' nodes. So this would grab the 'add' nodes in appSettings as well as connectionStrings and god only knows what else.

Collectives™ on Stack Overflow

PowerShell manipulating XML file issue

2 Answers 2

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related