In Powershell, how could I sort an array based on a substring within a string in the array?

Question

My array contains cpe:2.3:o:juniper:junos, cpe:2.3:h:hp, and cpe:2.3:a:microsoft:sql_server. I'd like to alphabetically sort this array based on the 4th substring, juniper, hp, and microsoft in this case. Substrings are delimited by a colon :.

This question is very similar to this one, but I'm looking for a Powershell way to do this. I've tried creating a regex to sort, but that proved to be difficult.

mklement0 · Accepted Answer · 2022-10-17 20:13:02Z

3

Use the Sort-Object cmdlet with a calculated property that uses the -split operator to sort by the token of interest:

$array = 'cpe:2.3:o:juniper:junos', 'cpe:2.3:h:hp', 'cpe:2.3:a:microsoft:sql_server'

$array | Sort-Object { ($_ -split ':')[3] }

Output (sorted by the 4th field):

cpe:2.3:h:hp
cpe:2.3:o:juniper:junos
cpe:2.3:a:microsoft:sql_server

edited Oct 17, 2022 at 20:13

answered Aug 8, 2022 at 23:24

mklement0

452k68 gold badges727 silver badges986 bronze badges

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

Collectives™ on Stack Overflow

In Powershell, how could I sort an array based on a substring within a string in the array?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related