topic Re: sort help in Operating System - Linux

sort help

Rinky — Tue, 21 Aug 2007 02:10:13 GMT

Hi experts,

I have a comma separated file.
The fourth field in the file is date of the form: DD-MON-YYYY format.
I wanted the file sorted according to the fourth field.
DD : 01-31
sort -knr4 wont work.
sort +3 -4 also dint work..

Please help.

Re: sort help

Steven E. Protter — Tue, 21 Aug 2007 02:16:45 GMT

Shalom,

From my new memory leak monitor.

CL="ps -o pid,args,sz,vsz | sort -nr -k 3,4| head -$NUM"

This sorts by field three then field 4.

All you need to do is get the field separator right.

I would suggest a combination of awk and sort.

SEP

Re: sort help

Dennis Handly — Tue, 21 Aug 2007 02:31:20 GMT

>I wanted the file sorted according to the fourth field.

You need to break up the fourth field into 3 fields with "." syntax.

>SEP: I would suggest a combination of awk and sort.

No need, sort(1) has enough horsepower:
sort -t, -k4.8n,4.11n -k4.4M,4.6M -k4.1n,4.2n file

Use the "." notation to get bytes within field 4. Use "M" to sort by months.

Re: sort help

Rinky — Tue, 21 Aug 2007 02:57:38 GMT

Thanks Dennis..
It worked exactly as I wanted...