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 a 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 Tiger in a Nutshell 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.