Powershell Select node by String value

Question

I`m trying to select one node, by string value of another node.

My Xml part:

          <XIP xmlns="http://prty/XIP/v6.0">
             <Generation>
               <Properties>
                 <Property>
                   <PUID>prp/10008</PUID>
                   <PropertyName>Number Of Audio Streams</PropertyName>
                   <Value>1</Value>
                 </Property>
                <Property>
                  <PUID>prp/12</PUID>
                  <PropertyName>Sampling Frequency</PropertyName>
                  <Value>48000</Value>
                </Property>
                <Property>
                  <PUID>prp/10002</PUID>
                  <PropertyName>Duration</PropertyName>
                  <Value>2M9.686S</Value>
                </Property>
             <Properties>
          <Generation>
        </XIP>

So, the idea is get 2M9.686S, by string Duration

$xmlDocument.XIP.Generation.Properties.Property.Value |  Where-Object $xmlDocument.XIP.Generation.Properties.Property -Property PropertyName -Like ("Duration")

I'm trying for different ways, but don't return any value. What am i doing wrong?

Thanks for any help.

Xml has errors no </Properties> or </Generation>.

js2010
– js2010

2020-06-12 17:15:20 +00:00
Commented Jun 12, 2020 at 17:15 — js2010
– js2010, Commented Jun 12, 2020 at 17:15

Victor Silva · Accepted Answer · 2020-06-12 17:43:16Z

1

You can navigate like this:

$xmlDocument.XIP.Generation.Properties.Property | where {$_.PropertyName -eq "Duration"}

to access to the specific Property and the followint to access to the Value, ie:

($xmlDocument.XIP.Generation.Properties.Property |
    where {$_.PropertyName -eq "Duration"}).value

(For replicate the scenario, I used the $xmlDocument = [xml](Get-Content .\test.xml) to save and access to the XML content)

edited Jun 12, 2020 at 17:43

answered Jun 12, 2020 at 14:48

Victor Silva

7804 silver badges17 bronze badges

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

3 Comments

Victor Silva Over a year ago

Thank you! I think that actually exist another best approach, but if it works, perfect!

js2010 Over a year ago

You don't need the backquote, a pipe can continue a line, among a lot of other things.

Paulo Over a year ago

Thanks js2010, i try your solution and works fine to!

js2010 · Accepted Answer · 2020-06-12 17:43:03Z

0

Here's the xpath version. The namespace adds a little complication. The double quotes are required, otherwise the pattern looks like an array.

$ns = @{x = 'http://prty/XIP/v6.0'}
select-xml "//*[x:PropertyName='Duration']" file.xml -Namespace $ns | 
  % {$_.node.value}

2M9.686S

answered Jun 12, 2020 at 17:43

js2010

28.3k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

Powershell Select node by String value

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related