Powershell Objects Sorting On Property - Descending - Not working

Question

I am sorting the contents of the a text file as below

APPLE|FINAL|20220122065900|0
APPLLE|PRE|20220122061500|0
MANGO|PRE|20220126113400|0
MANGO|PRE|20220125102200|0
MANGO|ASSYN|20220125102200|0

$file = Get-Content D:\FOXXXX\DOWNTIME\POWER\test.txt
Foreach($line in  $file)
{
     New-Object PSObject -Property @{
        "t1" = $line.split("|")[0]
        "t2" = $line.split("|")[1]
 } | Sort-Object -Property t1 -Descending |Select-Object t1, t2

}

I am getting the following output with no sorting. Please let me know what I am doing wrong

t1     t2   
--     --   
APPLE  FINAL
APPLLE PRE  
MANGO  PRE  
MANGO  PRE  
MANGO  ASSYN

Santiago Squarzon · Accepted Answer · 2022-01-28 05:26:16Z

4

You're sorting each element of the collection instead of sorting all the collection, in other words, Sort-Object should be outside the loop:

$collection = Foreach($line in $file)
{
    New-Object PSObject -Property @{
        "t1" = $line.split("|")[0]
        "t2" = $line.split("|")[1]
    }
}

$collection | Sort-Object -Property t1 -Descending

On the other hand, your text file is pipe delimited, you can use ConvertFrom-Csv or Import-Csv (if from a file) to convert it into an object:

@'
APPLE|FINAL|20220122065900|0
APPLLE|PRE|20220122061500|0
MANGO|PRE|20220126113400|0
MANGO|PRE|20220125102200|0
MANGO|ASSYN|20220125102200|0
'@ | ConvertFrom-Csv -Delimiter '|' -Header T1, T2 |
Sort-Object T1 -Descending

answered Jan 28, 2022 at 5:26

Santiago Squarzon

65.5k5 gold badges26 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

Powershell Objects Sorting On Property - Descending - Not working

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related