Hello,

I'm banging my head for an easy script to select a value regarding to another value in a semicolon and (!) new line separated variable ("matrix", "multi-dimensional array")

I have a variable like this:

$text='line1;30
line2;50
line3;20'

I want the name in column 1 which has the highest value in column 2 from the same line. In the example above the result should be 'line2'.

In this example

$text2='line-a;40
line-b;20
line-c;40'

the result should be 'line-a' or(!) 'line-c'.

Regards,

Something like this?

$csv = $text | ConvertFrom-Csv -Delimiter ';' -Header Line, Value
$max = ($csv.Value | Measure-Object -Maximum).Maximum
$csv | Where-Object Value -eq $max | Select-Object -ExpandProperty Line

In your second example, if you only want one of the lines you can do this:

$csv | Where-Object Value -eq $max | Select-Object -First 1 -ExpandProperty Line

• Edited by Leif-Arne Helland 9 hours 53 minutes ago
• Marked as answer by Stefan HorzMicrosoft community contributor 47 minutes ago

Something like this?

$csv = $text | ConvertFrom-Csv -Delimiter ';' -Header Line, Value
$max = ($csv.Value | Measure-Object -Maximum).Maximum
$csv | Where-Object Value -eq $max | Select-Object -ExpandProperty Line

In your second example, if you only want one of the lines you can do this:

$csv | Where-Object Value -eq $max | Select-Object -First 1 -ExpandProperty Line

• Edited by Leif-Arne Helland 9 hours 45 minutes ago
• Marked as answer by Stefan HorzMicrosoft community contributor 39 minutes ago

Something like this?

$csv = $text | ConvertFrom-Csv -Delimiter ';' -Header Line, Value
$max = ($csv.Value | Measure-Object -Maximum).Maximum
$csv | Where-Object Value -eq $max | Select-Object -ExpandProperty Line

In your second example, if you only want one of the lines you can do this:

$csv | Where-Object Value -eq $max | Select-Object -First 1 -ExpandProperty Line

• Edited by Leif-Arne Helland Wednesday, June 24, 2015 9:15 PM
• Marked as answer by Stefan HorzMicrosoft community contributor Thursday, June 25, 2015 6:21 AM

Something like this?

$csv = $text | ConvertFrom-Csv -Delimiter ';' -Header Line, Value
$max = ($csv.Value | Measure-Object -Maximum).Maximum
$csv | Where-Object Value -eq $max | Select-Object -ExpandProperty Line

In your second example, if you only want one of the lines you can do this:

$csv | Where-Object Value -eq $max | Select-Object -First 1 -ExpandProperty Line

• Edited by Leif-Arne Helland Wednesday, June 24, 2015 9:15 PM
• Marked as answer by Stefan HorzMicrosoft community contributor Thursday, June 25, 2015 6:21 AM

Thank you!