sort

pantera · 05-25-2004, 03:50 AM

how to sort a file according to a particular field
0.00
0.00
1
1
1
1
4
5
5
5
5.00
1.00
5.00
3.00
5.00
7.00

in the above file how can i sort it so that i can get
0.00
1.00
3.00
5.00
7.00
1
4
5

zeropash · 05-25-2004, 03:59 AM

sort -nu filename
or sort -gu filename
0.00
1
3.00
4
5
7.00

if you consider 5 to be separate from 5.0 then use

sort -n filename | uniq
this will give output of the form
0.00
1
1.00
3.00
4
5
5.00
7.00

mfeat · 05-25-2004, 10:07 AM

sort +0.1 file | uniq

zeropash · 05-26-2004, 07:21 AM

but wont that cause problems the moment you add say 1.10 to the list? ie the 1.10 will be placed behind 7.0?

jlliagre · 05-26-2004, 01:08 PM

Pantera, can you give more clues to the rest of us about the logic you want for the sort ?

Tinkster · 05-26-2004, 07:36 PM

sort -u -t. -g -k 2,2 pantera.txt

Not quite the order you wanted, but close enough?
I'm sure it's possible to tweak this with a few extra
-r's, but I can't be bothered messing around with it :)

The alternative would be to split the file using awk
or grep into two files, sort those, and then merge
them.

Cheers,
Tink