Parsing xml using powershell

by

First step is to load your xml string into an XmlDocument, using powershell’s
unique ability to cast strings to [xml]

$doc = [xml]@'
<xml>
    <Section name="BackendStatus">
        <BEName BE="crust" Status="1" />
        <BEName BE="pizza" Status="1" />
        <BEName BE="pie" Status="1" />
        <BEName BE="bread" Status="1" />
        <BEName BE="Kulcha" Status="1" />
        <BEName BE="kulfi" Status="1" />
        <BEName BE="cheese" Status="1" />
    </Section>
</xml>
'@

Powershell makes it really easy to parse xml with the dot notation. This
statement will produce a sequence of XmlElements for your BEName elements:

$doc.xml.Section.BEName

Then you can pipe these objects into the where-object cmdlet to filter down the
results. You can use ? as a shortcut for where

$doc.xml.Section.BEName | ? { $_.Status -eq 1 }

The expression inside the braces will be evaluated for each XmlElement in the
pipeline, and only those that have a Status of 1 will be returned. The $_
operator refers to the current object in the pipeline (an XmlElement).

If you need to do something for every object in your pipeline, you can pipe the
objects into the foreach-object cmdlet, which executes a block for every object
in the pipeline. % is a shortcut for foreach:

$doc.xml.Section.BEName | ? { $_.Status -eq 1 } | % { $_.BE + " is delicious" }

Powershell is great at this stuff. It’s really easy to assemble pipelines of
objects, filter pipelines, and do operations on each object in the pipeline.

More Related Contents:

  1. String handling from Powershell script
  2. Powershell script to delete 15 days old .txt files [duplicate]
  3. How to create a zip archive with PowerShell?
  4. How to run an EXE file in PowerShell with parameters with spaces and quotes
  5. Fastest Way to get a uniquely index item from the property of an array
  6. How do you run a SQL Server query from PowerShell?
  7. How to replace multiple strings in a file using PowerShell
  8. Combine `Get-Disk` info and `LogicalDisk` info in PowerShell?
  9. Powershell remoting with ip-address as target
  10. Merging multiple CSV files into one using PowerShell
  11. Obtaining ExitCode using Start-Process and WaitForExit instead of -Wait
  12. Maximize window and bring it in front with powershell
  13. Why and how are these two $null values different?
  14. A better way to check if a path exists or not in PowerShell [closed]
  15. ConvertTo-Csv Output without quotes
  16. Create directory if it does not exist
  17. Delete all files and folders but exclude a subfolder
  18. Start-Process with PowerShell.exe exhibits different behavior with embedded single quotes and double quotes
  19. How to split string by string in Powershell
  20. Powershell: Colon in commandlet parameters
  21. Why is $false -eq “” true?
  22. powershell function switch param with string array
  23. Is there an alternative to GUID when using msiexec to uninstall an application?
  24. What security setting is preventing Remote PowerShell 2.0 from accessing UNC paths
  25. PowerShell Capture Write-Host output
  26. start remote process within the context
  27. How to run powershell command in batch file
  28. How can I elevate Powershell while keeping the current working directory AND maintain all parameters passed to the script?
  29. Is there a PowerShell equivalent of `paste` (i.e., horizontal file concatenation)? [duplicate]
  30. Getting “Can’t find the drive. The drive called ‘IIS’ does not exist.”

Leave a Comment