Sort by the one of the columns at a time

hanae · 05-17-2012, 09:16 AM

I want to sort a file that I have by different sort criteria:
- in the alphabetic order first
- then group them by file name

This is the format of the file I have:

adfr file 5
axmll file 1
abcd file 4
xpmlm file 5
dmlp file 1

And I want to have two output files contain the results of the sorting
The first file like this:
abcd file 4
adfr file 5
axmll file 1
dmlp file 1
xpmlm file 5

The second file like this:
axmll file 1
dmlp file 1
abcd file 4
adfr file 5
xpmlm file 5

Can you please help me?
Thank you,

colucix · 05-17-2012, 10:00 AM

The sort command should do it flawlessly. What have you tried so far? sort alone (without options) sorts alphabetically starting from the first field, with -k option it sorts using the specified field. Option -n triggers numerical sorting. Please, see man sort for details.

hanae · 05-17-2012, 10:06 AM

I tried this this command:
- sort -s -n -k 1 filename, but it apparently, it doesn't recognize the first word as a column... can you please help?

blue_print · 05-17-2012, 10:13 AM

For first,

Code:

sort filename

For second

Code:

sort +2 -3 filename

hanae · 05-17-2012, 10:21 AM

Can you please explain what does this command mean:
sort +2 -3 filename

I tried it by it doesn't work, it just sort by the the filename?

I have the input like this

word filename token_number

blue_print · 05-17-2012, 10:28 AM

I just did try with yours,

Quote:

[root@server1 ~]# cat file
adfr file 5
axmll file 1
abcd file 4
xpmlm file 5
dmlp file 1
[root@server1 ~]# sort file
abcd file 4
adfr file 5
axmll file 1
dmlp file 1
xpmlm file 5
[root@server1 ~]# sort +2 -3 file
axmll file 1
dmlp file 1
abcd file 4
adfr file 5
xpmlm file 5

+2 - Sort with second line if 3rd column is same on more than one line
-2 - Do the sort based on 3rd column value

colucix · 05-17-2012, 10:32 AM

It would be clearer using the option -k explicitly:

Code:

sort -k3n file

which is the same as

Code:

sort -n -k3 file

hanae · 05-17-2012, 10:46 AM

I still cannot get the good result I want

This is a sample of the file I have

Quote:

sky losn_revue-1981-2 40234
fly kivre1-0-0 1236
able udrum-umuray-13238-5 469878
after article1-1-1.2 13265

when I tried the command it is sorted by the last number which is token_num but not by filename?

normally the output should be:

Quote:

after article1-1-1.2 13265
fly kivre1-0-0 1236
sky losn_revue-1981-2 40234
able udrum-umuray-13238-5 469878

Thank you,

colucix · 05-17-2012, 11:05 AM

You have to run two different commands to get two different results! Or am I missing something?

Code:

$ cat file
sky losn_revue-1981-2 40234
fly kivre1-0-0 1236
able udrum-umuray-13238-5 469878
after article1-1-1.2 13265 
$ sort file
able udrum-umuray-13238-5 469878
after article1-1-1.2 13265 
fly kivre1-0-0 1236
sky losn_revue-1981-2 40234
$ sort -k3n file
fly kivre1-0-0 1236
after article1-1-1.2 13265 
sky losn_revue-1981-2 40234
able udrum-umuray-13238-5 469878

blue_print · 05-17-2012, 11:07 AM

Quote:

Originally Posted by hanae

I still cannot get the good result I want

This is a sample of the file I have

when I tried the command it is sorted by the last number which is token_num but not by filename?

normally the output should be:

Thank you,

Well its working for me

Quote:

[root@server1 ~]# cat file1
sky losn_revue-1981-2 40234
fly kivre1-0-0 1236
able udrum-umuray-13238-5 469878
after article1-1-1.2 13265

[root@server1 ~]# sort +1 -2 file1
after article1-1-1.2 13265
fly kivre1-0-0 1236
sky losn_revue-1981-2 40234
able udrum-umuray-13238-5 469878

hanae · 05-17-2012, 11:19 AM

it is working for this specific case, but it is not with my whole file that contains thousands of file. AT a certain time the file is messed up.

aDuR Essai12-50-4 5273
ap CORPUS-131-18 5274
ira LMA_der12_20061219.058-29-13 5274
pymunt Doc_de_synthFse-127-9 5274
irumiYyn LKA_de_20061219.038-38-21 5275
issflid LKA_de_20061219.057-37-110 5275
rad Biographies1-92-3 5275
yxddm uddur-n-umur-105-5 5275
ayt LMA_BER_20061219.040-119-5 5276
i Livres1-70-5 5276
ittuyassann Reb1-49-13 5276
mani Fossman_revu-164-1 5276
n LMA_DE_20061219.020-42-100 5276
tn CORPUS-131-19 5277
a LMA_DE_20061219.058-29-14 5278

hanae · 05-18-2012, 04:18 AM

can someone help me figure out what is the problem??