Windows 10: sorting columns in CSV file with powershell

I have a csv file with 1600 lines from which top ten lines given below
N,EQ,ADANIPORTS,ADANI PORT & SEZ LTD,384.5,385,387.8,375,376.75,792818726.1,2085488,Y, ,40850,452.35,350.45
N,EQ,ASIANPAINT,ASIAN PAINTS LIMITED,1394.75,1395,1411,1385.05,1393.5,1284559258,919355,Y, ,36117,1490.6,1090.1
N,EQ,AXISBANK,AXIS BANK LIMITED,631.75,638.05,643.4,634,639.9,9599936309,15035968,Y, ,144038,644.65,447.5
N,EQ,BAJAJ-AUTO,BAJAJ AUTO LIMITED,2685.55,2683.9,2697,2664,2682.25,1476618943,551229,Y, ,23611,3468.35,2605
N,EQ,BAJAJFINSV,BAJAJ FINSERV LTD.,7092.1,7092,7129,7025.25,7050.65,909166393.3,128111,Y, ,19707,7200,4500
N,EQ,BAJFINANCE,BAJAJ FINANCE LIMITED,2893.85,2892,2943.4,2891.05,2916.6,3884349778,1327710,Y, ,52356,2943.4,1511.2
N,EQ,BHARTIARTL,BHARTI AIRTEL LIMITED,369.9,370,370.8,365,368.95,768282183.8,2089422,Y, ,26515,564.8,331
N,EQ,BPCL,BHARAT PETROLEUM CORP LT,357.75,358.25,362,353.5,356.95,1738725370,4865929,Y, ,77863,551.55,353.5
N,EQ,CIPLA,CIPLA LTD,657.95,658,658,645,651.2,1235846442,1904031,Y, ,38575,665,507.2
N,EQ,COALINDIA,COAL INDIA LTD,289.05,287.85,293.6,287.8,291,791484837,2713583,Y, ,55421,316.95,235.85

I wanted to sort 10 the column in descending order so that top 20 I can find out.
The file name is Pd240818.csv
my powershell code is as below.
# To remove unwanted few lines
sls ",BE,",",EQ," .\Pd240818.csv | select -exp line | Where-Object {$_ -notmatch ',EQ, ,'} > .\temp.csv
#Sorting line is as follows
gc .\temp.csv | Where-Object {$_ -notmatch 'MKT,'}|%{$_.split(",")[9]}|Sort-Object -Descending| Select-Object -first 20 > temp.txt
Sorted

I get temp.txt as follows
99988.7
99896.5
9989273.6
99769.75
996134.55
9933960.45
99228.65
99199.95
989418.15
988423057.7
9884111.1
98572145.2
982146.5
981497584.9
97982.75
9786178.9
9775915.05
9760482.5
97384498.85
971033.85

Where as if I sort the same column in excel, I get as below.
28818819313 9599936309 8459873415 6175554483 5889553012 5690666055 5439638100 5121938441 5079530750 5042021707 4972762046 4889394601 4742835986 3884349778 3690976213 3486309023 3388956937 3336437125 3206801588 3114870807 Where am I doing wrong. How to correct it?

:)

 

Sorting column of mixed format data

You would need to do this:

• Create an extra column to the right of plot numbers.
• Copy the plot numbers from the left to the right column.
• Remove all letters from the left column.
• Remove all numbers from the right column.
• Place a space or an exclamation mark into all empty cells in the right column.
• Sort the list against the left plus the right column.
• Replace each exclamation mark with a space.

 

Sorting Explorer columns by multiple criteria


I also haven't seen the capability of multiple sort criteria in many versions of Windows Explorer or the later [in Win8/8.1/10] File Explorer. Each column visible can be sorted in ascending or descending order, clicking a different column changes the view strictly to that arrangement. Generally the columns are sorted alphabetically with Folders first. Compressed/zip files are usually between Folders and files except in Type where they will be at either end of the list.

 

CSV files used to open in Excel....not now!


Hi, you say Excel is installed. Does it run normally?

You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

For example, in the list related to:
- rt click a file. Open With
- this list:



- this list:




- some other list...

If Excel does not appear in the above, I suggest you repair your office installation.

Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.