Hi all,
Sorry the title is a mess, but did not find a better description at the time.
So here is my problem:
I have an input file:
How can I sort it first by name and then by number (like one does in excel for example).
I tried with

Code:

sort -t : -k2,1 input_file

and other combinations (k1,2;k2,2...etc) but it sorts either the first field (numeric) or the second one.

Note: I know the input file is exactly like I´m asking it to be, but this is a very small part of the input file where all the data are scrambled. So please take this in account.


Also if I have a input file like:
Why the sort -n input_file command sorts by number and produce an output (for example):
If you notice, you can see that it sorts by the first field and the third also, and I don't want that, I just one the first field sorted so that the upper line stays on top and not on below or bottom according to its value.

For this I tried

Code:

sort -n -t : k1,1 input_file

and

Code:

sort -t : k1,1 -n input_file

but none of them work.


So I hope you guys can shed some light on this issue as I need to make this easy to read and copy for my weekly reports.

I´m open to any suggestions whether in sort or awk commands.

Thanks and I hope I was clear enough.