Use PowerShell to Parse an XML File and Sort the Data

re: Use PowerShell to Parse an XML File and Sort the Data

Butler — Fri, 22 Jun 2012 13:52:52 GMT

Hi Scripting Guy

You saved my bacon today!! Thanks for the tutorial.

re: Use PowerShell to Parse an XML File and Sort the Data

jrv — Mon, 26 Mar 2012 16:06:16 GMT

The following is a great place for XPath novices to start learning. The turorial has online test faculity so you can try as you go. And oh! It's Free!

www.w3schools.com/xpath

YouTube is now loaded with many XPath and XSLT videos.

re: Use PowerShell to Parse an XML File and Sort the Data

K_Schulte — Mon, 26 Mar 2012 10:51:04 GMT

One thing, I forgot to ask yesterday:

"Could you provide a link to the books.xml file or at least publish a listing of the content, please!?"

Klaus

re: Use PowerShell to Parse an XML File and Sort the Data

K_Schulte — Mon, 26 Mar 2012 10:36:27 GMT

Hi Teresa, Hi Ed,

I just visited the PoshCode site and successfully logged into my old account.

In fact I looked a bit over my old scripts and some other scripts just to bring back old memories :-) Amazing that this has been only 11 months ago ...

Back to this blog entry: filtering, sorting, grouping and searching XML content is something that we can do with Powershell-on-board-tools and that's really a help if we can't use other specialized tools. I don't know much about the upcoming PS V3 CTP2, so I only can hope, that the XML support has been one of the subject that might have been extended or improved in the new version. Up to now only Select-Xml and the specialized Get-WinEvent cmdlet support XPATH parameters which should be the preferred way of selecting XML nodes. Other XML topics like XSLT stylesheet transformations are missing competely in Powershell v1 and v2 but as usual could be accomplished by means of the underlying .Net framework v2.0 ( or 4.0 later on )

Again: It's good to have a basic XML toolkit around in Powershell ...

Klaus