Need to extract value of attribute from xml from Command promt [closed]

by

There are literally tons of sample scripts, and docs all over the web explaining and showing how to deal with this use case…

Example: https://www.red-gate.com/simple-talk/sysadmin/powershell/powershell-data-basics-xml

… including discussions on this site.

Though the XML snippet is not complete and you should really provide a more complete one, one can assume what it would look like.

Outside of that, you are not showing what you’ve really tried, meaning your full code effort, and you should for us to really be able to guide you.

Nonetheless, PowerShell has built-in XML cmdlets to deal with XML files …

Get-Command -Name '*xml*' | ft -a

CommandType Name              Version Source
----------- ----              ------- ------
Cmdlet      ConvertTo-Xml     3.1.0.0 Microsoft.PowerShell.Utility
Cmdlet      Convert-XMLtoJSON 5.0.0.1 Sorlov.PowerShell
Cmdlet      Export-Clixml     3.1.0.0 Microsoft.PowerShell.Utility
Cmdlet      Import-Clixml     3.1.0.0 Microsoft.PowerShell.Utility

# Get examples of how to use Select-Xml
Get-Help -Name Select-Xml -Examples

https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.utility/select-xml?view=powershell-6

($MyXml | Select-Xml -XPath "//House").Node.id

# Results
R91958E89-39D6-467C-A149-1674CA7A6D6E

… or you can use the .Net name space for them and cherry pick the data you are after.

[xml]$MyXml = @"
<Homes>
<Home>
    <House id="R91958E89-39D6-467C-A149-1674CA7A6D6E" Address="XYZ" MEMBER="10"/>
</Home>    
</Homes>
"@ 

# Get the house id
$MyXml.Homes.Home.House.id

# Or 
$MyXml.SelectSingleNode('//House').id

# Results for both commands
R91958E89-39D6-467C-A149-1674CA7A6D6E

More Related Contents:

  1. Running a powershell command using full path and arguments from command line [duplicate]
  2. Merging multiple CSV files into one using PowerShell
  3. How to run an application as “run as administrator” from the command prompt? [closed]
  4. How can I get the file system location of a PowerShell script?
  5. CMD or Powershell command to combine (merge) corresponding lines from two files [duplicate]
  6. How to call batch script from Powershell?
  7. PowerShell The term is not recognized as cmdlet function script file or operable program
  8. How to run powershell command in batch file
  9. Using PowerShell credentials without being prompted for a password
  10. PowerShell and the -contains operator
  11. Powershell function call changing passed string into int
  12. Different behaviour and output when piping in CMD and PowerShell
  13. How to handle failed variable assignments in powershell? [duplicate]
  14. Redirecting standard input\output in Windows PowerShell
  15. How to perform keystroke inside powershell?
  16. How to get an object’s property’s value by property name?
  17. Reload the path in PowerShell
  18. Why does ‘continue’ behave like ‘break’ in a Foreach-Object?
  19. Why don’t .NET objects in PowerShell use the current directory?
  20. Timing a command’s execution in PowerShell
  21. How can I display my current git branch name in my PowerShell prompt?
  22. How remove accents in PowerShell?
  23. Why does “Get-ChildItem -File | Get-FileHash” work?
  24. Get the drive letter of USB drive in PowerShell
  25. Is there a way to pass serializable objects to a PowerShell script with start-process?
  26. How to use PowerShell copy-item and keep structure
  27. Powershell Using Start-Process in PSSession to Open Notepad
  28. Powershell Get-ChildItem most recent file in directory
  29. How to download the SSL certificate from a website using PowerShell?
  30. Powershell – Output Color for certain results

Leave a Comment