Question:
I want to sort a text file in PowerShell. The text file looks like this:
|
1 2 3 4 5 |
name1 4 name2 2.3 name3 6.7 name4 5.1 |
I want to output that file like this:
|
1 2 3 4 5 |
name3 6.7 name4 5.1 name1 4 name2 2.3 |
As you can see, it is ordered descending by the number associated to the name.How do I do that?
Answer:
You can sort by an expression, split each line (space delimiter), cast the last item to system.double and sort on it:
|
1 2 |
Get-Content .\file.txt | Sort-Object { [double]$_.split()[-1] } -Descending |