Sum value of XML attributes using PowerShell 2.0

Posted by Yooakim on Stack Overflow See other posts from Stack Overflow or by Yooakim
Published on 2010-06-08T05:11:02Z Indexed on 2010/06/08 5:22 UTC
Read the original article Hit count: 290

Filed under:

Xml

|

powershell-v2.0

I have a directory with XML files. I quickly want to go through them and sum upp the value stored in one attribute. I have figured out how to fidn the nodes I am interested in.

For example:

(Select-Xml -Path .\*.xml -XPath "//*[@Attribue = 'valueImlookingfor']").Count

This command gives me the count of elements in all of the XML files in the current directory which has the value "valueImlookingfor" in the "Attribue".

I want to sum up all the values of the "Attribute", not count them. What would be the best way to do this in PowerShell? I am new to PowerShell so this may be trivial but un-known to me...

All tips are much appreciated :-)

© Stack Overflow or respective owner

Related posts about Xml

Store XML,update record in XML,retrive a specific record in XML stored on BB device

as seen on Stack Overflow - Search for 'Stack Overflow'
I am writing a blackberry application where i want to store the data returned by a web service in my BB device.Earlier i was going to use SQLite for storing the data in mobile but as i googled and also did programming using SQLite and found that some BB devices dont support SQLite library and fail… >>> More
gwt+xml- can i read through incomplete XML using the GWT XML Parser

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a requirement where a user is typing in XML in a text area, and I want to show the various nodes in a tree...But as the user is typing in the xml, it wont be a complete xml (since he is still typing in the XML)... How do I read an incomplete XML and correctly generate the tree? I understand… >>> More
perl xml parser get xml content within xml

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I use XMLParser to get the item-@url, item-@replace and item-"value inside" for the content as a string of the node where item-@cone="one"? <cstep> <item cone="one" url="http://google.com/{ccc}/cthree" replace="{ccc}"> <itemsub conesub="conesub"> … >>> More
Reading php generated XML in flash?

as seen on Stack Overflow - Search for 'Stack Overflow'
Here is part 1 of our problem (Loading a dynamically generated XML file as PHP in Flash). Now we were able to get Flash to read the XML file, but we can only see the Flash render correctly when tested(test movie) from the actual Flash program. However, when we upload our files online to preview the… >>> More
Announcing RSS feeds of Microsoft All-In-One Code Framework code samples

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Today, we are not only announcing Sample Browser v2 CTP, but we are also excited to announce the availability of RSS feeds of All-In-One Code Framework code samples. By using these feeds, you can easily track and download the new code samples. English RSS feeds All code samples: http://support… >>> More

Related posts about powershell-v2.0

powershell v2 remoting - How do you enable unecrypted traffic

as seen on Server Fault - Search for 'Server Fault'
I'm writing a powershell v2 script that I'd like to run against a remote server. When I run it, I get the error : Connecting to remote server failed with the following error message : The WinRM client cannot process the request. Unencrypted traffic is currently disabled in the client … >>> More
Increase number of concurrent shells in PowerShell V2

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to increase number of concurrent shells in PowerShell V2.I tried using the following command ,but I got no luck.The error I got is" Error: Invalid use of command line. Type "winrm -?" for help." Can someone shine some light? winrm set winrm/config/winrs @{MaxShellsPerUser="50"} >>> More
Increase number of concurrent shells in PowerShell V2

as seen on Server Fault - Search for 'Server Fault'
I'd like to increase number of concurrent shells in PowerShell V2.I tried using the following command ,but I got no luck.The error I got is" Error: Invalid use of command line. Type "winrm -?" for help." Can someone shine some light? winrm set winrm/config/winrs @{MaxShellsPerUser="50"} >>> More
Windows 7: run powershell v2 from start menu's run command

as seen on Super User - Search for 'Super User'
When I open Start menu in Windows 7 and press Run and then write "Powershell" the powershell v1 starts. How to start powershell v2 using the same invoking method? >>> More
Load-Module equivalient in PowerShell v1

as seen on Server Fault - Search for 'Server Fault'
(Cross-post from Stackoverflow) For reasons of script portability, I need to dynamically load snap-ins in a PowerShell script (ie. I don't want to actually install it). This is easily accomplished in PowerShell v2 with the Load-Module function. I need to run this particular script on a machine where… >>> More