powershell sort multidimensional array

Question

I am a newbie in Powershell, but this is driving me a bit crazy. I have looked at various questions here, but could not find an answer so here I go. Apologies if this has been covered already.

I have two text files containing columns of numbers. I would like to create an array containing those 2 columns and sort it by column 1 or 2.

If we had

$a=@(1,5,10,15,25)
$b=@(100,99,98,99,10)

we create

c$=$a,$b

My initial thought was to try something like this:

$c | sort { [int]$_[0] }

But it does not work. I have tried many different things so any advice would be appreciated.

I am editing this as my question was not so clear. Ultimately, if I sort $c by ascending column 2, I expect something like:

Any idea how to achieve this ?

Are these arrays declared the way you thing they are currently? Right now is sort of has a horizontal relationship and not a vertical one that you expect. It sounds like you think the array is declared like so $c = @(@(1,100),@(5,99),@(10,98),@(15,99),@(25,10)) or at least it would be easier to work with like that or if nothing else transform it to work like that. — Matt
– Matt, Commented Apr 8, 2015 at 13:07

Matt · Accepted Answer · 2015-04-08 13:21:37Z

5

I am not sure about how you have declared your dimensional array because it is like you want it to be declared like this or something similar

$c = @(@(1,100),@(5,99),@(10,98),@(15,99),@(25,10))

If it was in that state then sorting is a breeze

$c | Sort-Object @{Expression={$_[1]}; Ascending=$True} | %{
    "$($_[0]),$($_[1])"
}

Sort-Object works well with one dimensional arrays. When multiple properties are involved you need to specify which property to sort on to get the expected output. Since there are none we use a calculated expression to make on base on the second "column".

Sample Output

If you really want to work with your arrays like that we need an intermediate step to convert what you have to how it can be sorted the way you expect.

$a=@(1,5,10,15,25)
$b=@(100,99,98,99,10)
$c = @()
for($i = 0;$i -lt $a.Count; $i++){
    $c += ,@($a[$i],$b[$i])
}

After running this code $c will work just like it does with my sorting.

edited Apr 8, 2015 at 13:21

answered Apr 8, 2015 at 13:12

Matt

47k9 gold badges90 silver badges125 bronze badges

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

3 Comments

Octave Over a year ago

Many thanks for your help. I thought there was no need to do that conversion, hence my problem.

Matt Over a year ago

@Octave Do you understand / Have anymore questions about this? Or is this satisfactory. It is possible to work with your arrays differently but like I said your input does not seem to match your desired output.

Octave Over a year ago

I think that's fine. Thanks again.

Naigel · Accepted Answer · 2015-04-08 11:58:12Z

1

Welcome to powershell world. The syntax is slightly different from classical programming languages, usually cmdlets take their input from current pipeline. In this case the command you talk about is Sort-Object and you can use it directly with the pipe content where you have the array content

$c = ($a | Sort-Object), ($b | Sort-Object)

answered Apr 8, 2015 at 11:58

Naigel

9,76417 gold badges73 silver badges111 bronze badges

1 Comment

Octave Over a year ago

Many thanks for your reply. I edited my question as I need to sort column1 by column 2.

Collectives™ on Stack Overflow

powershell sort multidimensional array

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related