Click on any of the 687 commands below to get a description and list of available options. All links in the command summaries point to the online version of the book on Safari Bookshelf.
Join lines of two sorted files by matching on a common field. If either file1 or file2 is -, read from standard input. Often used to merge data stored in text-based file formats such as comma-separated-value formatted spreadsheets.
Options
-afilenum
Print a line for each unpairable line in file filenum, in addition to the normal output.
-estring
Replace missing input fields with string.
-i, --ignore-case
Ignore case differences when comparing keys.
-1fieldnum1
The join field in file1 is fieldnum1. Default is the first field.
-2fieldnum2
The join field in file2 is fieldnum2. Default is the first field.
-ofieldlist
Order the output fields according to fieldlist, where each entry in the list is in the form filenum.fieldnum. Entries are separated by commas or blanks.
-tchar
Specifies the field-separator character (default is whitespace).