Sort command giving wrong output

usha rao · #1 (**permalink**) 04-03-2009

Hi all,
I have a problem with sort command.
i have a file which looks like this:

Code:

 
"file1
1073 java/4
1073 java/180
1073 java/170
1073 java/176
1073 java/167
1073 java/40
1073 java/33
1073 java/136
28988 java/76
28988 java/73
28988 java/48
28988 java/26"

and i want to sort this file according to the number which comes after java/

so i am using this command:

Code:

 
"cat file1 | awk -F"/" '{print $2}' | sort "

but the output i am getting is

Code:

and as you can see it is not at all sorted.
Please advice/Thanks

vgersh99 · #2 (**permalink**) 04-03-2009

Code:

 nawk -F/ '{printf("%s\t%s\n", $NF, $0)}' file1 | sort -k1n | cut -f2-

# or simply

sort -t/ -k2n file1

pludi · #3 (**permalink**) 04-03-2009

Quote:

Originally Posted by usha rao

Code:

and as you can see it is not at all sorted.

Yes, it is. 136 has alphabetical precedence to 167. Same for 167 and 170, 170 and 176, ... If you want to have it sorted on numerical value instead of character order, use the -n switch

Beast Of Bodmin · #4 (**permalink**) 04-03-2009

Code:

sort -t/ -k2n file1
1073 java/4
28988 java/26
1073 java/33
1073 java/40
28988 java/48
28988 java/73
28988 java/76
1073 java/136
1073 java/167
1073 java/170
1073 java/176
1073 java/180

Code:

cut -d/ -f2 file1 | sort -n
4
26
33
40
48
73
76
136
167
170
176
180

usha rao · #5 (**permalink**) 04-05-2009

Hi All,
Thanks for your replies.
It works.
Just one doubt if the same thing i want to sort in reverse order,will that be possible.

pludi · #6 (**permalink**) 04-05-2009

After invoking the Names of Cthulhu and Yog-Sothoth, asking for their guidance, a voice from the darkest reaches of the Netherworld told me: "Try sort --help". And lo, there was a bright text saying

Code:

  -r, --reverse               reverse the result of comparisons

usha rao · #7 (**permalink**) 04-06-2009

Hey thanks pludi.I tried it earlier,may be my syntax was wrong.It gave me command garbled.But now i corrected it.Its working now.Thanks all for your help.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
AWK command giving wrong input	usha rao	UNIX for Dummies Questions & Answers	3	04-01-2009 04:41 AM
Shared memory giving wrong value	ajaysahoo	AIX	1	12-29-2008 06:42 AM
What's going wrong with sort?	Digby	Shell Programming and Scripting	7	09-03-2008 06:31 AM
script not giving the desired output	Renjesh	Shell Programming and Scripting	2	06-15-2008 03:58 AM
Script giving wrong results....	mgirinath	Shell Programming and Scripting	1	12-21-2005 09:45 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: