Merge XML attributes for output

Question

I would like to create a txt file report about installed products. I get these information from an XML document with the following structure:

<xmlroot>
 <product definitionName="ProductName" versionMajor="1" versionMinor="1" versionBuild="111">
 </product>

Now, after I filtered by definitionName, I want to write a file with two colomns "ProductName" and "Version" by concatenating the versions like this "1.1.111".

When I do this:

$ProductVersions.xmlroot.product | Select-Object -Property definitionName, versionMajor,     versionMinor, versionBuild

I get a list like this:

definitionName                                  versionMajor                                   versionMinor                                    versionBuild                                  
--------------                                  ------------                                   ------------                                    ------------                                  
ProductName                                     1                                               1                                               111

What I want is a list like this:

ProductName                                   Version                          
--------------                                ------------                              
ProductName                                   1.1.111

Please help me to find a way. Thank you.

Duncan · Accepted Answer · 2014-02-27 21:47:04Z

2

Try this:

PS C:\> $ProductVersions.xmlroot.product |
 Select-Object -Property @{n='ProductName';e={$_.definitionName}}, @{n='Version';e={"$($_.versionMajor).$($_.versionMinor).$($_.versionBuild)"}}

ProductName                                                               Version                                                                 
-----------                                                               -------                                                                 
ProductName                                                               1.1.111

Slightly cleaner version suggested by @Ansgar Wiechars:

PS C:\> $ProductVersions.xmlroot.product |
 Select-Object -Property @{n='ProductName';e={$_.definitionName}},
  @{n='Version';e={"{0}.{1}.{2}" -f $_.versionMajor, $_.versionMinor, $_.versionBuild}}

ProductName                                                               Version                                                                 
-----------                                                               -------                                                                 
ProductName                                                               1.1.111

edited Feb 27, 2014 at 21:47

answered Feb 27, 2014 at 21:22

Duncan

96.4k15 gold badges129 silver badges160 bronze badges

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

2 Comments

Ansgar Wiechers Over a year ago

You could also use the format operator instead of subexpressions: "{0}.{1}.{2}" -f $_.versionMajor, $_.versionMinor, $_.versionBuild

Duncan Over a year ago

@AnsgarWiechers, I've added that version to my answer.

Collectives™ on Stack Overflow

Merge XML attributes for output

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related