Name
join
Synopsis
join [options
]file1 file2
Joins the common lines of sorted file1
and
sorted file2
. Reads standard input if
file1
is -
. The output
contains the common field and the remainder of each line from
file1
and
file2
. In the following options,
n
can be 1 or 2, referring to
file1
or file2
.
Options
-
-a
[n
] List unpairable lines in file
n
(or both ifn
is omitted).-
-e
s
Replace any empty output field with the string
s
.-
-j
n m
Join on the
m
th field of filen
(or both files ifn
is omitted).-
-o
n
.m
Each output line contains fields specified by file number
n
and field numberm
. The common field is suppressed unless requested.-
-t
c
Use character
c
as field separator for input and output.-
-v
n
Print only the unpairable lines in file
n
. With both-v
1
and-v
2
, all unpairable lines are printed.-
-1
m
Join on field
m
offile1
. Fields start with 1.-
-2
m
Join on field
m
offile2
. Fields start with 1.
Examples
Assuming the following input files:
$cat score
olga 81 91 rene 82 92 zack 83 93 $cat grade
olga B A rene B A
List scores followed by grades, including unmatched lines:
$ join -a1 score grade
olga 81 91 B A
rene 82 92 B A
zack 83 93
Pair each score with its grade:
$ join -o 1.1 1.2 2.2 1.3 2.3 score grade
olga 81 B 91 A
rene 82 B 92 A
Get Mac OS X Panther in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.