SORT:Sorting lines

[Ellinas]

i have a question..
i have this file:

John Jones
John Smith
Jack Smith
100100 13
Helen Bold
100200 5

how can i use sort to make it look like :

Helen Bold
John Jones
Jack Smith
John Smith
100100 13
100200 5

Surname as the major key ,firstname as the minor key and numbers at the
end.

i've read the man pages and sort -k 2,2 -k 1,1 file
will sort the surname and the first name but the numbers appear at the top..

why?

 

[PHV]

This works for me:
LANG=french_france.8859 sort -k 2,2 -k 1,1 file

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ellinas]

nope..not for me ..still the numbers at the top

 

[PHV]

And this ?
LC_ALL=fr_FR sort -k 2,2 -k 1,1 file

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ellinas]

$ LC_ALL=fr_FR sort -k 2,2 -k 1,1 file.awk
100100 13
100200 5
Helen Bold
John Jones
Jack Smith
John Smith


nope .
is there another way of doing it? i mean like using awk or somthing

 

[PHV]

And this ?
(grep -v '^[0-9]' file | sort -k 2,2 -k 1,1; grep '^[0-9]' file | sort -k 2,2 -k 1,1) > output

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ellinas]

i cant believe it ...it workd..thank SOO much..i got stuck for a while....thanz again