JOIN(1L) JOIN(1L) NNAAMMEE join - join lines of two files on a common field SSYYNNOOPPSSIISS jjooiinn [-a 1|2] [-v 1|2] [-e empty-string] [-o field- list...] [-t char] [-j[1|2] field] [-1 field] [-2 field] file1 file2 jjooiinn {--help,--version} DDEESSCCRRIIPPTTIIOONN This manual page documents the GNU version of jjooiinn. jjooiinn prints to the standard output a line for each pair of input lines, one each from _f_i_l_e_1 and _f_i_l_e_2, that have identical join fields. Either filename (but not both) can be `-', meaning the standard input. _f_i_l_e_1 and _f_i_l_e_2 should be already sorted in increasing order (not numeri- cally) on the join fields; unless the _-_t option is given, they should be sorted ignoring blanks at the start of the line, as ssoorrtt does when given the _-_b option. The defaults are: the join field is the first field in each line; fields in the input are separated by one or more blanks, with leading blanks on the line ignored; fields in the output are separated by a space; each output line consists of the join field, the remaining fields from _f_i_l_e_1, then the remaining fields from _f_i_l_e_2. OOPPTTIIOONNSS _-_a _f_i_l_e_-_n_u_m_b_e_r Print a line for each unpairable line in file _f_i_l_e_- _n_u_m_b_e_r (either 1 or 2), in addition to the normal output. _-_e _s_t_r_i_n_g Replace empty output fields (those that are missing in the input) with _s_t_r_i_n_g. _-_1_, _-_j_1 _f_i_e_l_d Join on field _f_i_e_l_d (a positive integer) of file 1. _-_2_, _-_j_2 _f_i_e_l_d Join on field _f_i_e_l_d (a positive integer) of file 2. _-_j _f_i_e_l_d Equivalent to _-_1 _f_i_e_l_d _-_2 _f_i_e_l_d. _-_o _f_i_e_l_d_-_l_i_s_t_._._. Construct each output line according to the format in _f_i_e_l_d_-_l_i_s_t. Each element in _f_i_e_l_d_-_l_i_s_t consists of a file number (either 1 or 2), a period, and a field number (a positive integer). The elements in the list are separated by commas or blanks. Multi- ple _f_i_e_l_d_-_l_i_s_t arguments can be given after a sin- gle _-_o option; the values of all lists given with FSF GNU Text Utilities 1 JOIN(1L) JOIN(1L) _-_o are concatenated together. _-_t _c_h_a_r Use character _c_h_a_r as the input and output field separator. _-_v _f_i_l_e_-_n_u_m_b_e_r Print a line for each unpairable line in file _f_i_l_e_- _n_u_m_b_e_r (either 1 or 2), instead of the normal out- put. In addition, when GNU jjooiinn is invoked with exactly one argument, the following options are recognized: _-_-_h_e_l_p Print a usage message on standard output and exit successfully. _-_-_v_e_r_s_i_o_n Print version information on standard output then exit successfully. FSF GNU Text Utilities 2 .