Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Sort by the third column with +n command Post 302086394 by vgersh99 on Wednesday 23rd of August 2006 03:56:39 PM
Old 08-23-2006
Code:
sort -k3n,3 data.file

or 

sort -b -k3n,3 data.file

These 2 Users Gave Thanks to vgersh99 For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Question about sort specific column and print other column at the same time !

Hi, This is my input file: ali 5 usa abc abu 4 uk bca alan 6 brazil bac pinky 10 utah sdc My desired output: pinky 10 utah sdc alan 6 brazil bac ali 5 usa abc abu 4 uk bca Based on the column two, I want to do the descending order and print out other related column at the... (3 Replies)
Discussion started by: patrick87
3 Replies

2. Shell Programming and Scripting

sort on second column only based on first column

I have an input file like this... AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Sunlight AAAlkalines Sunlight AAAlkalines Sunlight AAAlkalines Energizer AAAlkalines Energizer AAAlkalines Energizer AAASalines ... (7 Replies)
Discussion started by: malcomex999
7 Replies

3. 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

4. UNIX for Dummies Questions & Answers

Sort on one column only

Hello, I am running on AIX.I have a question about sorting in UNIX. if my file is something like this: a c b d a b b c a a I want to sort on column 1 only. The following statement does not seem to work, it still considers the rest of the line in the sorting results: sort... (2 Replies)
Discussion started by: gio001
2 Replies

5. Shell Programming and Scripting

Edit column using sort

Hi Expert, Please kindly need your help, I dont have any idea how to make this input to be as output. Thanks before $ more input.dat @zmap_fault HEADER , FALT, 80, 1 X (EASTING) , 1, 1, 1, 1, 15, 7, 0.1000000E+31, , 15, 7, 0 Y... (5 Replies)
Discussion started by: ipatah
5 Replies

6. UNIX for Dummies Questions & Answers

Sort command in one column and not effect to another column

If my data is numerical : 1 = 101 2 = 102 3 = 104 4 = 104 7 = 103 8 = 103 9 = 105 I need the result like below: 1 = 101 2 = 102 3 = 103 4 = 103 7 = 104 8 = 104 9 = 105 (4 Replies)
Discussion started by: GeodusT
4 Replies

7. Shell Programming and Scripting

Sort on column

How to sort based on the 4 the column . The input data has a header and output needs to be sorted based on the 4th column rbcid. I tried below code but not getting results sort -u -t'|' -k4,4r file1 > file2 time|tourit|nofdays|rbcid|blank|type|value|nill|valuedesc|name... (6 Replies)
Discussion started by: samrat dutta
6 Replies

8. UNIX for Dummies Questions & Answers

Sort each column independently

Hi, I have a file full of this fields and rows: 0.269330|0.035118|0.526763|0.792274 0.33555|19.471911|51.844968|1631 ... 3.981490|5.062725|17.190744|111 0.000000|0.030234|0.000000|1631 ... ... I'd like to sort EACH column individually based on the value after the third "|".... (12 Replies)
Discussion started by: a_bahreini
12 Replies

9. UNIX for Dummies Questions & Answers

Custom sort on a column

Hello all, How do I achieve this? I have A, B and A/B in different variables in a file in col2. I want them to sort in such a way, that the variables appear together, and within a variable, the data is sorted in the order A,B and then A/B. If I sort on the second column, the order becomes A,... (6 Replies)
Discussion started by: senhia83
6 Replies

10. Shell Programming and Scripting

Use sort to sort numerical column

How to sort the following output based on lowest to highest BE? The following sort does not work. $ sort -t. -k1,1n -k2,2n bfd.txt BE31.116 0s 0s DOWN DAMP BE31.116 0s 0s DOWN DAMP BE31.117 0s 0s ... (7 Replies)
Discussion started by: sand1234
7 Replies
RECVSTATS(8)						      System Manager's Manual						      RECVSTATS(8)

NAME
recvstats - summarize HylaFAX receive accounting information SYNOPSIS
/usr/sbin/recvstats [ options ] [ files ] DESCRIPTION
recvstats is a command script that prints a summary of the HylaFAX accounting statistics for received facsimile. The statistics can be sorted using one of several keys: the caller's CSI (default), CIDName (CallID2), CIDNumber (CallID1), the communication speed, or the com- munication data format. Statistics are read from the file /var/spool/hylafax/log/xferfaxlog unless filenames are specified on the command line. The following table is an example of the output from recvstats (using the default sort key): Sender CIDName CIDNumber Pages Time Pg/min Errs TypRate TypData 61 30:47 2.0 16 9600 1-DMR +13037904674 5 1:34 3.2 2 9600 1-DMH +14159657824 1 1:00 1.0 0 9600 1-DMH +15086636852 2 0:00 2.0 0 9600 1-DMH +15105268781 740 5:47:51 2.1 59 9600 1-DMH +15105287164 20 7:00 2.9 0 9600 1-DMH +15123713545 3 1:19 2.3 0 9600 1-DMH +15123713641 5 1:04 4.6 0 9600 1-DMH +16099211926 3 2:00 1.5 0 9600 1-DMH +17088987617 1 0:18 3.3 0 9600 1-DMH 415 390 6175 22 6:01 3.6 0 9600 1-DMH 415 965 7651 56 34:52 1.6 14 9600 1-DMH 415 973 6723 1 2:09 0.5 0 9600 2-DMR 49 211 161514 1 0:00 1.0 0 9600 2-DMR 8185970503 1 0:28 2.1 0 9600 2-DMR ALDUS CORPORATION ALDUS CO 5551212 3 2:34 1.2 0 9600 1-DMH -------------------------------------------------------------------------------------------------- Total 925 7:19:03 2.1 91 The Sender column shows the caller's TSI (notice that some callers have not setup a TSI). The CIDName column is the received CIDName value for the sender. The CIDNumber column is the received CIDNumber value for the sender. The Pages column is the total number of good pages received. The time column shows the total amount of time spent receiving facsimile from a sender. The Pg/min column displays the average transfer rate. The Errs column indicates how many protocol errors were encountered while receiving facsimile. The TypRate column displays the most common communication speed with which facsimile were received. The TypData column shows the most common data format in which fac- simile data were received. OPTIONS
-age days Show information only for the facsimile received in the last specified number of days. -csi* Sort output by caller's CSI. -cidname Sort output by CIDName -cidnumber Sort output by CIDNumber -format Sort output by data format. -send* Sort output by sender (i.e. caller's CSI). -speed Sort output by signalling rate. -since time Show information only for the facsimile received since the specified time; where time is of the form ``MM/DD/YY HH:MM'' (the date(1) format string %D %H:%M). -end time Show information only for the facsimile received before the specified time; where time is of the same form as since. FILES
/var/spool/hylafax spooling area /var/spool/hylafax/log/xferfaxlog default file from which to read statistics SEE ALSO
faxq(8), xferfaxstats(8), hylafax-log(5) March 3, 1995 RECVSTATS(8)
All times are GMT -4. The time now is 07:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy