05-19-2008
Sort Descending
HI,
i want to sort values in descending order and get the column no.s of the sorted value. my data will look like:
subject 1 2 3 4 5
bob 78 45 89 99 54
i want the score to be sorted in descending and get the corresponding subject sorted in the output. Please help me with gawk or ??
Any help is greatly appreciated!
Thanks
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
What is the command used by sysadmin to see the disk used by the users in descending order of their disk usage? (8 Replies)
Discussion started by: asutoshch
8 Replies
2. Shell Programming and Scripting
Dear All,
I have below attached file in which i have many nos, i want the last ascending order nos. The brief description is given below.
File
315
381
432
315
381
432
315
381
432
315
381
432
315
381
432 (6 Replies)
Discussion started by: pravani1
6 Replies
3. UNIX for Dummies Questions & Answers
How can I sort a file as follows ?
cols 1 - 10 ascending
cols 11 - 18 descending
cols 19 - 20 ascending
Thanks (1 Reply)
Discussion started by: don_0110
1 Replies
4. Shell Programming and Scripting
Hi
I have a problem with sort command :
sort -nk 1.28,1.34 file | sort -nrk 1.27 file | sort -nk 1.22,1.25 file |sort -nk 1.13,1.21 file | sort -nk 1.9,1.12 file | sort -nk 1.1,1.8 file
This is the input file
0000000100010000000200004090317003
0000000100010000000230001020592002... (3 Replies)
Discussion started by: Fafa
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I want to short descending all the files according to their size.Please help me.. (1 Reply)
Discussion started by: jyotidas
1 Replies
6. Shell Programming and Scripting
Input file
9.99331e-13
8.98451e-65
9.98418e-34
7.98319e-08
365592
111669
74942.9
0
Desired output
365592
111669
74942.9
7.98319e-08
1.99331e-13
6.98418e-34 (2 Replies)
Discussion started by: perl_beginner
2 Replies
7. Shell Programming and Scripting
hi all
i want to remove some descending order number
example :
1 100 200 135.00 Gk_wirs 1
1 100 200 136.00 Gk_wirs 50
1 110 210 138.00 Gk_wirs 60
1 100 200 136.00 Gk_wirs 57 ----> how to remove... (6 Replies)
Discussion started by: nithyanandan
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am trying to sort the following file in descending order of its fourth column.
2 1 363828 -2.423225e-03
3 1 363828 4.132763e-03
3 2 363828 8.150133e-03
4 1 363828 4.126890e-03
I use
sort -k4,4g -r input.txt > output.txt ... (1 Reply)
Discussion started by: evelibertine
1 Replies
9. Shell Programming and Scripting
Hi,
I have a problem . I have few directories like inpTDT_1, inpTDT_2, inpTDT_3 and so on inside HOME directory . In one of my perl script (which is in my HOME), the above directories like inpTDT_1, inpTDT_2, inpTDT_3 are sorting out in an order So I wanted to sort all the inpTDT_1, inpTDT_2,... (1 Reply)
Discussion started by: venkatesh
1 Replies
SORT(1) General Commands Manual SORT(1)
NAME
sort - sort a file of ASCII lines
SYNOPSIS
sort [-bcdfimnru] [-tc] [-o name] [+pos1] [-pos2] file ...
OPTIONS
-b Skip leading blanks when making comparisons
-c Check to see if a file is sorted
-d Dictionary order: ignore punctuation
-f Fold upper case onto lower case
-i Ignore nonASCII characters
-m Merge presorted files
-n Numeric sort order
-o Next argument is output file
-r Reverse the sort order
-t Following character is field separator
-u Unique mode (delete duplicate lines)
EXAMPLES
sort -nr file # Sort keys numerically, reversed
sort +2 -4 file # Sort using fields 2 and 3 as key
sort +2 -t: -o out # Field separator is :
sort +.3 -.6 # Characters 3 through 5 form the key
DESCRIPTION
Sort sorts one or more files. If no files are specified, stdin is sorted. Output is written on standard output, unless -o is specified.
The options +pos1 -pos2 use only fields pos1 up to but not including pos2 as the sort key, where a field is a string of characters delim-
ited by spaces and tabs, unless a different field delimiter is specified with -t. Both pos1 and pos2 have the form m.n where m tells the
number of fields and n tells the number of characters. Either m or n may be omitted.
SEE ALSO
comm(1), grep(1), uniq(1).
SORT(1)