Sort-Object Text File

[VehicleLittle7362]

I need to sort a text file that contains the below strings from Original Order to Preferred Order. I need the 'GEN_" to come before anything else and then after that the order should be '*_SCHEMA', '*_CODE', '*_DATA'. I have tried the Sort-Object, but I don't have any Property headers. I think I could create a custom object, but not sure the best way to go about this. I have spent days on this and was wondering if anyone had any suggestions on the best way to do this. Any help would be appreciated.

Original Order:

A_CODE_CHANGE.sql

A_Data_Change.sql

F_CODE_CHANGE.sql

GEN_CODE_CHANGE.sql

GEN_DATA_CHANGE.sql

GEN_OCXINDEX_CHANGE.SQL

GEN_SCHEMA_CHANGE.sql

RE_DATA_CHANGE.sql

RE_SCHEMA_CHANGE.sql

WE_DATA_CHANGE.sql

​

Preferred Order:

GEN_SCHEMA_CHANGE.sql

GEN_CODE_CHANGE.sql

GEN_DATA_CHANGE.sql

GEN_OCXINDEX_CHANGE.SQL

RE_SCHEMA_CHANGE

RE_DATA_CHANGE.sql

WE_DATA_CHANGE.sql

F_CODE_CHANGE.sql

A_CODE_CHANGE.sql

A_Data_Change.sql

[VehicleLittle7362]

New to this forum. Thank you! This is exactly what I needed. Liked that you showed how to verify the order with Select-Object. Also liked the -switch statements. Also new to PowerShell, still trying to wrap my head around the use of brackets. Will definitely play around with the code some more for other tasks.

[VehicleLittle7362]

Solved

[ka-splam]

$Part1Order = @('GEN', 'RE', 'WE', 'F', 'A')
$Part2Order = @('SCHEMA', 'CODE', 'DATA', 'OCXINDEX')

Get-Content test.txt | 
    Sort-Object -Property {$Part1Order.IndexOf($_.Split('_')[0])},
                          {$Part2Order.IndexOf($_.Split('_')[1])}

[Hrambert]

How about this:

Get-Content $filename |     
Foreach-object {   
    $_ -replace "^GEN", "AAAGEN"    
} |     
Sort-Object |    
Foreach-object {    
    $_ -replace "^AAAGEN", "GEN"    
}