topic Sort command has incorrect results or I don't know what I'm doing in Operating System - Linux

Sort command has incorrect results or I don't know what I'm doing

Kurt Redlitz — Tue, 21 Aug 2007 11:29:47 GMT

I need to sort the following (example) by
they second field(date) and then the third
field (time), using the comma as the field
separator.

1,20051018,154700,67
2,20051018,142000,8
3,20051020,1111,67
4,20051020,222,8

Using cat txt | sort -t , -k2n -k3n
does not produce the correct results, (but
does on other OS's). It comes out like this:
4,20051020,222,8
3,20051020,1111,67
2,20051018,142000,8
1,20051018,154700,67

(The correct results should have the first
fields as 2,1,4,3)

I cannot seem to find
any parameters to get this to sort properly.

HP-UX B.11.11 U 9000/800

Re: Sort command has incorrect results or I don't know what I'm doing

OldSchool — Tue, 21 Aug 2007 11:37:30 GMT

sort -t, -k2,2n -k3,3n

"cat" isn't necessary btw

Re: Sort command has incorrect results or I don't know what I'm doing

Sandman! — Tue, 21 Aug 2007 11:38:02 GMT

Works for me...what OS are you running this on?

# cat infile
1,20051018,154700,67
2,20051018,142000,8
3,20051020,1111,67
4,20051020,222,8

# sort -t, -k2,2n -k3,3n infile
2,20051018,142000,8
1,20051018,154700,67
4,20051020,222,8
3,20051020,1111,67

Re: Sort command has incorrect results or I don't know what I'm doing

OldSchool — Tue, 21 Aug 2007 11:41:31 GMT

check the man page regarding keydefs, if you don't specify the ending field, it sorts using startfield thru end of line. the -k2,2n restricts the first sort key to the second field only, the 3,3 does the third likewise

Re: Sort command has incorrect results or I don't know what I'm doing

Kurt Redlitz — Tue, 21 Aug 2007 11:44:12 GMT

Thanks so much, I missed the part about the using the end of the line if the field-end is not specified.

Re: Sort command has incorrect results or I don't know what I'm doing

Dennis Handly — Sat, 08 Sep 2007 02:54:40 GMT

You haven't assigned any points yet. Please read:
http://forums1.itrc.hp.com/service/forums/helptips.do?#33

You should also close this thread indicating you have a solution.

Re: Sort command has incorrect results or I don't know what I'm doing

Kurt Redlitz — Mon, 10 Sep 2007 08:41:40 GMT

The solution was provided in the replies.