06-30-2008
Sort on two keys
Hello,
I am trying to sort a text file by two keys but the second key should be reversed.
I have tried -nt '|' -k 4 -rk 5 but it just sorts reversed on key 4.
Does anyone have any suggestions ?
Thanks
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to use the arrow keys in shell scripting. is there any special synatax / command for this.
i just want to use the arrow keys for navigation.
replies appreciated
raguram R (3 Replies)
Discussion started by: raguramtgr
3 Replies
2. UNIX for Advanced & Expert Users
Hello,
Say I have a file with plain text as shown below. Some columns may have multiple words (like "DESC 1", "DESC 1 2", "DESC 1 2 3"). Let's say the file below has 4 columns: 1st(AA), 2nd(BB), 3rd(DESC 1, ...), 4th(CC 1, ...).
1234567890123456789012345678901234567890
AA BB DESC 1... (1 Reply)
Discussion started by: teqmem
1 Replies
3. Shell Programming and Scripting
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. Shell Programming and Scripting
Hi All,
I am having knowledge on some basics of ssh and wanted to know what are the public keys and how can we create and implement it in connecting server.
Please provide the information for the above, it would be helpful for me.
Thanks,
Ravindra (1 Reply)
Discussion started by: ravi3cha
1 Replies
5. UNIX for Advanced & Expert Users
Hello all -
I am to this forum and fairly new in learning unix and finding some difficulty in preparing a small shell script. I am trying to make script to sort all the files given by user as input (either the exact full name of the file or say the files matching the criteria like all files... (3 Replies)
Discussion started by: pankaj80
3 Replies
6. Shell Programming and Scripting
Can you guys pls take a look at this.
I need to sort this list of numbers as follows:
2nd col first, then 1st col, then 3rd col, all in reverse (highest to lowest).
I'm doing this:
sort -k 2,2nr -k 1,1nr -k 3,3gr
but, as you see, the 3rd col does not get sorted properly.
Any idea... (0 Replies)
Discussion started by: mamboknave
0 Replies
7. Shell Programming and Scripting
sort --random-sort
The full command is
path=`find /testdir -maxdepth 1 -mindepth 1 -type d | ***Some sort of sort function*** | head -1`
I have a list I want to randomly sort. It works fine in ubuntu but on a 'osx lion' sort dosen't have the --random-sort option.
I don't want to... (5 Replies)
Discussion started by: digitalviking
5 Replies
8. Shell Programming and Scripting
Input file:
100%ABC2 3.44E-12 USA
A2M%H02579 0E0 UK
100%ABC2 5.34E-8 UK
100%ABC2 3.25E-12 USA
A2M%H02579 5E-45 UK
Output file:
100%ABC2 3.44E-12 USA
100%ABC2 3.25E-12 USA
100%ABC2 5.34E-8 UK
A2M%H02579 0E0 UK
A2M%H02579 5E-45 UK
Code try:
sort -k1,1 -g -k2 -r input.txt... (2 Replies)
Discussion started by: perl_beginner
2 Replies
9. Shell Programming and Scripting
Hi Experts,
I have a filelist collected from another server , now want to sort the output using date/time stamp filed.
- Filed 6, 7,8 are showing the date/time/stamp.
Here is the input:
#----------------------------------------------------------------------
-rw------- 1 root ... (3 Replies)
Discussion started by: rveri
3 Replies
10. UNIX for Dummies Questions & Answers
Please suggest a sort command to achieve the below task. Thanks.
I want to sort a file considering multiple keys.
Sort Keys: Field 2, Field4 and Field6
Input file
vqrs,16,zzz,1235,eq,T
abcd,11,zzz,1234,pq,F
abcd,10,zzz,1235,pq,F
lqrs,15,zzz,1235,eq,T
pqrs,12,zzz,1234,eq,F... (3 Replies)
Discussion started by: pretty1234
3 Replies
refer(1) User Commands refer(1)
NAME
refer - expand and insert references from a bibliographic database
SYNOPSIS
refer [-ben] [-ar] [-cstring] [-kx] [-lm,n] [-p filename] [-skeys] filename...
DESCRIPTION
refer is a preprocessor for nroff(1), or troff(1), that finds and formats references. The input files (standard input by default) are
copied to the standard output, except for lines between `.[' and `.]' command lines, Such lines are assumed to contain keywords as for
lookbib(1), and are replaced by information from a bibliographic data base. The user can avoid the search, override fields from it, or add
new fields. The reference data, from whatever source, is assigned to a set of troff strings. Macro packages such as ms(5) print the fin-
ished reference text from these strings. A flag is placed in the text at the point of reference. By default, the references are indicated
by numbers.
When refer is used with eqn(1), neqn, or tbl(1), refer should be used first in the sequence, to minimize the volume of data passed through
pipes.
OPTIONS
-b Bare mode -- do not put any flags in text (neither numbers or labels).
-e Accumulate references instead of leaving the references where encountered, until a sequence of the form:
.[
$LIST$
.]
is encountered, and then write out all references collected so far. Collapse references to the same source.
-n Do not search the default file.
-ar Reverse the first r author names (Jones, J. A. instead of J. A. Jones). If r is omitted, all author names are reversed.
-cstring Capitalize (with SMALL CAPS) the fields whose key-letters are in string.
-kx Instead of numbering references, use labels as specified in a reference data line beginning with the characters %x; By
default, x is L.
-lm,n Instead of numbering references, use labels from the senior author's last name and the year of publication. Only the first
m letters of the last name and the last n digits of the date are used. If either of m or n is omitted, the entire name or
date, respectively, is used.
-p filename Take the next argument as a file of references to be searched. The default file is searched last.
-skeys Sort references by fields whose key-letters are in the keys string, and permute reference numbers in the text accordingly.
Using this option implies the -e option. The key-letters in keys may be followed by a number indicating how many such
fields are used, with a + sign taken as a very large number. The default is AD, which sorts on the senior author and date.
To sort on all authors and then the date, for instance, use the options `-sA+T'.
FILES
/usr/lib/refer directory of programs
/usr/lib/refer/papers directory of default publication lists and indexes
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWdoc |
+-----------------------------+-----------------------------+
SEE ALSO
addbib(1), eqn(1), indxbib(1), lookbib(1), nroff(1), roffbib(1), sortbib(1), tbl(1), troff(1), attributes(5)
SunOS 5.10 14 Sep 1992 refer(1)