04-16-2010
Hi vgersh99,
Thanks but I actually want a sort based on the string values. I try to understand that 2nd output as it's a mystery to me!
Jgt,
wait i'm not sure I understand. i thought -kX1,Y1 -kX2, Y2... meant that the sort were to happen on field X1 to Y1 and to X2 to Y2. Does it have to do with the position of CHARACTER, not field??
9 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Sorta new to Unix. great site here.
I have SCO server with (5) 16 port Digi-boards and 5 line printers. For 3 years we've had no problems, till now... All of a sudden I get terminals and printers locking up. Killed the PID's for these particular situations. No help. So I disable the tty post... (10 Replies)
Discussion started by: ftn96
10 Replies
2. IP Networking
Hey folks, I've been charged with the job of finding out who's been screwing around with the download counts on our site. So now I have this huge list of IP's that I supposed to match to such and such developer.
I was told by one guy that I should just do a traceroute and that'd tell me where... (2 Replies)
Discussion started by: DumDum
2 Replies
3. Solaris
Hello Everyone,
I am currently running a large Server with Veritas Volumen Manager, attached to a EMC.
uname -a
SunOS 5.8 Generic_117350-47 sun4u sparc SUNW,Sun-Fire-880
I have one directory that tends to change to a file.Once in a while and always in different time.The file is the... (1 Reply)
Discussion started by: Peterh
1 Replies
4. UNIX for Advanced & Expert Users
A perplexing mystery...
please note that i am not a lacky, and the error below is misleading
recently something i do all the time broke (a script).
now when i run this script i get this error.
/usr/bin/awk: 0403-027 The parameter list is too long.
note that the (parameter list is... (9 Replies)
Discussion started by: nullwhat
9 Replies
5. Filesystems, Disks and Memory
I burned identical raw encrypted data to three cds using my new external Toshiba drive. My internal IBM read only drive does not get an I/O Error when reading in Circumstance #1, but does get an I/O Error in Circumstance #2. But, the Toshiba drive can do both circumstances without an error.
... (1 Reply)
Discussion started by: darkstarxor
1 Replies
6. Shell Programming and Scripting
Can I make use of two command variable in case statement
case $2 $3 in
stp)
Firewall disabled
echo " Changing the http Proxy configuration "
;;
str)
Firewall enabled
echo " Setting right http Proxy... (4 Replies)
Discussion started by: raghunsi
4 Replies
7. UNIX for Dummies Questions & Answers
Hello,
running AIX 6.1
# ls -la /home/user1
drwxrwxrwx 8 user1 staff 4096 Apr 19 2011 .
drwxr-xr-x 8 bin bin 256 Feb 08 2011 ..
drwx---r-x 2 user1 staff 256 Apr 13 2011 dir1
# su - user2
$ cd /home/user1
$ ls dir1
ls: dir1: The file... (1 Reply)
Discussion started by: vilius
1 Replies
8. UNIX for Advanced & Expert Users
Hi Folks,
I am running on a CentOS 6.3 server, whose primary function until recently has been my Zimbra mail server exclusively. I added wordpress and I have not been disappointed, with this one exception of Apache mod_rewrite. I have already tried to set selinux to permisive to eliminate that... (5 Replies)
Discussion started by: cjm51213
5 Replies
9. Shell Programming and Scripting
so i noticed that when a shell script has a function defined in it, running "sh -x" on that shell script from the command line doesnt show what the function is doing. i like this.
is there anyway for anyone to get around that? to be able to see exactly what a function or functions are doing? (4 Replies)
Discussion started by: SkySmart
4 Replies
LEARN ABOUT DEBIAN
plan9-join
JOIN(1) General Commands Manual JOIN(1)
NAME
join - relational database operator
SYNOPSIS
join [ options ] file1 file2
DESCRIPTION
Join forms, on the standard output, a join of the two relations specified by the lines of file1 and file2. If one of the file names is the
standard input is used.
File1 and file2 must be sorted in increasing ASCII collating sequence on the fields on which they are to be joined, normally the first in
each line.
There is one line in the output for each pair of lines in file1 and file2 that have identical join fields. The output line normally con-
sists of the common field, then the rest of the line from file1, then the rest of the line from file2.
Input fields are normally separated spaces or tabs; output fields by space. In this case, multiple separators count as one, and leading
separators are discarded.
The following options are recognized, with POSIX syntax.
-a n In addition to the normal output, produce a line for each unpairable line in file n, where n is 1 or 2.
-v n Like -a, omitting output for paired lines.
-e s Replace empty output fields by string s.
-1 m
-2 m Join on the mth field of file1 or file2.
-jn m Archaic equivalent for -n m.
-ofields
Each output line comprises the designated fields. The comma-separated field designators are either 0, meaning the join field, or
have the form n.m, where n is a file number and m is a field number. Archaic usage allows separate arguments for field designators.
-tc Use character c as the only separator (tab character) on input and output. Every appearance of c in a line is significant.
EXAMPLES
sort /etc/passwd | join -t: -1 1 -a 1 -e "" - bdays
Add birthdays to the /etc/passwd file, leaving unknown birthdays empty. The layout of /adm/users is given in passwd(5); bdays con-
tains sorted lines like
tr : ' ' </etc/passwd | sort -k 3 3 >temp
join -1 3 -2 3 -o 1.1,2.1 temp temp | awk '$1 < $2'
Print all pairs of users with identical userids.
SOURCE
/src/cmd/join.c
SEE ALSO
sort(1), comm(1), awk(1)
BUGS
With default field separation, the collating sequence is that of sort -b -ky,y; with -t, the sequence is that of sort -tx -ky,y.
One of the files must be randomly accessible.
JOIN(1)