powershell xml select attribute value where clause

Question

I have a xml file with the following elements:

<telecom use="HP" value="tel:+1-512-555-1212" />
<telecom use="WP" value="tel:+1-512-123-4567" />

this returns the value of the first node:

$qrda.ClinicalDocument.recordTarget.patientRole.telecom[0].value

However I need to be able to return the node where use="HP" and I'm not certain they'll always be in the correct order.

Any help is much appreciated.

G42 · Accepted Answer · 2017-07-21 14:06:56Z

2

The non-XPATH method:

($qrda.ClinicalDocument.recordTarget.patientRole.telecom | Where {$_.use -eq "HP"}).value

Or (thanks to Tomalak's helpful comment), using the comparison statement format:

($qrda.ClinicalDocument.recordTarget.patientRole.telecom | Where use -eq "HP").value

edited Jul 21, 2017 at 14:06

answered Jul 21, 2017 at 13:44

G42

10.1k2 gold badges22 silver badges36 bronze badges

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

2 Comments

Tomalak Over a year ago

The short form, ($qrda.ClinicalDocument.recordTarget.patientRole.telecom | Where use -eq "HP") should also be possible.

G42 Over a year ago

@Tomalak Thanks - tested, it worked, added to answer.

Tomalak · Accepted Answer · 2017-07-21 13:37:43Z

1

Use XPath. Assuming that $qrda is your XML document:

$path = "/ClinicalDocument/recordTarget/patientRole/telecom[@use='HP']"
$telecom = $qrda.SelectSingleNode($path)

since that path is pretty long and overly specific we can trim it down:

$telecom = $qrda.SelectSingleNode("//telecom[@use='HP']")

answered Jul 21, 2017 at 13:37

Tomalak

339k68 gold badges547 silver badges635 bronze badges

2 Comments

gnixon14 Over a year ago

This did not work for me. But seeing as how my xml doc is from the government, it's not surprising.

Tomalak Over a year ago

That has nothing to do with the government and everything with your question not showing the XML file itself. My answer is a best guess under these circumstances.

Collectives™ on Stack Overflow

powershell xml select attribute value where clause

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related