Sort Command


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sort Command
# 1  
Old 12-09-2003
Sort Command

Hello,

We are sorting a huge file (tab delimited) using the "sort" command.
The command is as given below,

sort -o/home/jay/sortres -t\"\t\" +10.0 -11.0 +0.0 -1.0r /home/jay/testsort

Please could anyone tell me ... what exactly will this command do ... i mean, how do these '+10' , '-11' work ..


Thank you,
- Jay.
# 2  
Old 12-09-2003
from the man pages
man sort

+POS1 [-POS2]
Specify a field within each line to use as a sort-
ing key. The field consists of the portion of the
line starting at POS1 and up to (but not including)
POS2 (or to the end of the line if POS2 is not
given). The fields and character positions are
numbered starting with 0.

-k POS1[,POS2]
An alternate syntax for specifying sorting keys.
The fields and character positions are numbered
starting with 1.

A position has the form f.c, where f is the number of the
field to use and c is the number of the first character
from the beginning of the field (for +pos) or from the end
of the previous field (for -pos). The .c part of a posi-
tion may be omitted in which case it is taken to be the
first character in the field. If the -b option has been
given, the .c part of a field specification is counted
from the first nonblank character of the field (for +pos)
or from the first nonblank character following the previ-
ous field (for -pos).

A +pos or -pos argument may also have any of the option
letters Mbdfinr appended to it, in which case the global
ordering options are not used for that particular field.
The -b option may be independently attached to either or
both of the +pos and -pos parts of a field specification,
and if it is inherited from the global options it will be
attached to both. If a -n or -M option is used, thus
implying a -b option, the -b option is taken to apply to
both the +pos and the -pos parts of a key specification.
Keys may span multiple fields.
# 3  
Old 12-09-2003
Originally posted by
sort -o/home/jay/sortres -t\"\t\" +10.0 -11.0 +0.0 -1.0r /home/jay/testsort


baiscally +1 -2 means sort on the second field,

i.e +1 mean from the second field it will take they key it will ignore the first key.

-2 means upto the second field.

In your command +0.0 and -1.0r seems to be obsolete for *r* option you can give simply -r remove that +0.0 and try, the result will be the same. The ouput will be sorted in the reverse order (because of -r) based on the 11th field.

Regards
JK
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help to sort out... Possible use of sort command

I have an input like 4.3.6.66 4.3.6.67 4.3.6.70 4.3.6.25 4.3.6.15 4.3.6.54 4.3.6.44 4.3.6.34 4.3.6.24 4.3.6.14 4.3.6.53 4.3.6.43 4.3.6.49 4.3.6.33 4.3.6.52 4.3.6.19 4.3.6.58 4.3.6.42 (5 Replies)
Discussion started by: dnam9917
5 Replies

2. Shell Programming and Scripting

Help with sort command

I have a file with the following content:- 181268525,0640613864,B,113,22-dec-2011 14:12:08, 181268525,0640613864,C,113,25-dec-2011 14:18:50, 181268525,0640613864,L,113,26-dec-2011 14:07:46, 181268525,0640613864,X,113,01-jan-2012 16:57:45, 181268525,0640613864,X,113,04-jan-2012 14:13:27,... (3 Replies)
Discussion started by: Yoda
3 Replies

3. Shell Programming and Scripting

Is it Possible to sort a list of hexadecimal numbers using "sort" command?

Hello Everybody :) !!!. i have question in mind, is it possible to sort a list of hexadecimal numbers using "sort" command? (9 Replies)
Discussion started by: Kesavan
9 Replies

4. Homework & Coursework Questions

Sort command

I have file ipaddress.txt 192.168.1.25 127.3.9.12 192.168.12.1 127.21.2.3 127.92.80.6 192.168.4.5 I want to sort as 127.3.9.12 127.21.2.3 127.92.80.6 192.168.1.25 192.168.12.1 192.168.4.5 So what sort command do I have to use. (1 Reply)
Discussion started by: RiderOnsky
1 Replies

5. Shell Programming and Scripting

How to Sort Floating Numbers Using the Sort Command?

Hi to all. I'm trying to sort this with the Unix command sort. user1:12345678:3.5:2.5:8:1:2:3 user2:12345679:4.5:3.5:8:1:3:2 user3:12345687:5.5:2.5:6:1:3:2 user4:12345670:5.5:2.5:5:3:2:1 user5:12345671:2.5:5.5:7:2:3:1 I need to get this: user3:12345687:5.5:2.5:6:1:3:2... (7 Replies)
Discussion started by: daniel.gbaena
7 Replies

6. Shell Programming and Scripting

Need help with sort command

Hi i have a file containing ip addresses and want to sort those IP addresses in the ascending order. file (match.txt) contents are: 192.168.0.100 192.168.0.16 192.168.0.10 192.168.0.23 192.168.0.2 192.168.0.3 192.168.0.1 192.168.0.222 i tried: sort -n match.txt output is :... (3 Replies)
Discussion started by: manmeet
3 Replies

7. UNIX for Dummies Questions & Answers

sort command...

Hi IŽd like to get a few explanations about how the sort command works when cascading the options. cscyabl@comet:(develop)> more file 2:A2 2:A1 5:A2 5:A2 10:A1 cscyabl@comet:(develop)> sort -n -u file 2:A1 5:A2 10:A1 cscyabl@comet:(develop)> sort -u -n file 2:A1 5:A2 10:A1... (8 Replies)
Discussion started by: Indalecio
8 Replies

8. UNIX for Dummies Questions & Answers

sort command

Hi, I am going to sort a huge flat file using sort command, this file is about 36 million lines, 179 fields delimitered by Ctrl B (002). eg. 1^B198709..... 17^B200301.... 3^B196511.... ..... I want this file being sorted by the first field, the result is like : 1^B198709........ (2 Replies)
Discussion started by: xli
2 Replies

9. UNIX for Dummies Questions & Answers

Help with the Sort command

Can someone please tell me how to sort a file, based on a particular position within the file? I have a line sequential file that is 152 bytes per record, in which i need to sort the file based on the numeric data in positions 142-152. I have done the "man sort" command and see the -k option... (1 Reply)
Discussion started by: rjjenkin
1 Replies
Login or Register to Ask a Question