Return to join CVS log

Up to [MW Coherent from dump] / coherent / a / usr / man / COHERENT

Annotation of coherent/a/usr/man/COHERENT/join, revision 1.1.1.1

1.1       root        1: 
                      2: 
                      3: join                         Command                         join
                      4: 
                      5: 
                      6: 
                      7: 
                      8: Join two data bases
                      9: 
                     10: jjooiinn [-aa [_n] ] [-ee _s_t_r_i_n_g ] [-jj[_n] _k_e_y_f] [-oo _n._m ...] [-tt_c] _f_i_l_e_1 _f_i_l_e_2
                     11: 
                     12: join processes the text files file1 and file2, each of which con-
                     13: tains a  relational data base.   If either file name  is `-', the
                     14: standard input is used for that file.
                     15: 
                     16: For the  purposes of  join, a  data base file  contains a  set of
                     17: records, one  per input line.   Each record contains  a number of
                     18: fields.  One field is  differentiated as key field for each file.
                     19: Each file must be sorted by key field, for example with sort.
                     20: 
                     21: By default, the key field is the first field in each record.  The
                     22: -j option  changes the key  field number to keyf  for the desired
                     23: file.  In this and  other options below, the optional file number
                     24: n must be 1 to indicate file1 or 2 to indicate file2.  If no n is
                     25: given, both file1 and file2 are assumed.
                     26: 
                     27: Normally,  fields are  separated  by any  amount  of white  space
                     28: (blanks or tabs).  Leading blanks or tabs are not considered part
                     29: of the fields.  With the -t option, the separator character is c.
                     30: With this  option zero-length  fields are possible;  every occur-
                     31: rence of  the separator ends the previous field  and starts a new
                     32: one.
                     33: 
                     34: Output consists only of records for which the key field occurs in
                     35: both files.   As a consequence of the sorted  order of the input,
                     36: the output  is also sorted by the key  field.  Each output record
                     37: has first  the key field,  then each field from  the file1 record
                     38: but the key field, and then  each field from the file2 record but
                     39: the  key field.   Fields  are separated  in the  output with  the
                     40: specified field  character, or  with a  space character if  no -t
                     41: option was  given.  Output records  are always terminated  with a
                     42: newline.  Under  the -e option, string is  printed for each empty
                     43: field.
                     44: 
                     45: The -a  option enables printing of records found  in only file n.
                     46: If n  is missing,  unpaired records  are printed from  both input
                     47: files.  To  output only certain fields, the  -o option precedes a
                     48: list of desired fields to print.  Each element is of the form n.m
                     49: where n is the file number and m is the field number.
                     50: 
                     51: For example,
                     52: 
                     53: 
                     54:         join -t: -j1 3 -o 1.3 2.4 1.4 1.1 2.2 filea fileb
                     55: 
                     56: 
                     57: joins filea  and fileb which  have fields separated  by the colon
                     58: (`:') character.  The join field number  is 3 for filea and 1 (by
                     59: default) for fileb.  The selected five fields are produced in the
                     60: output.
                     61: 
                     62: 
                     63: 
                     64: COHERENT Lexicon                                           Page 1
                     65: 
                     66: 
                     67: 
                     68: 
                     69: join                         Command                         join
                     70: 
                     71: 
                     72: 
                     73: ***** See Also *****
                     74: 
                     75: awk, comm, commands, sort, uniq
                     76: 
                     77: 
                     78: 
                     79: 
                     80: 
                     81: 
                     82: 
                     83: 
                     84: 
                     85: 
                     86: 
                     87: 
                     88: 
                     89: 
                     90: 
                     91: 
                     92: 
                     93: 
                     94: 
                     95: 
                     96: 
                     97: 
                     98: 
                     99: 
                    100: 
                    101: 
                    102: 
                    103: 
                    104: 
                    105: 
                    106: 
                    107: 
                    108: 
                    109: 
                    110: 
                    111: 
                    112: 
                    113: 
                    114: 
                    115: 
                    116: 
                    117: 
                    118: 
                    119: 
                    120: 
                    121: 
                    122: 
                    123: 
                    124: 
                    125: 
                    126: 
                    127: 
                    128: 
                    129: 
                    130: COHERENT Lexicon                                           Page 2
                    131: 
                    132: 

This archive runs on limited infrastructure. Preserving old code on modern bandwidth. Automated agents are requested to crawl responsibly.