join(1)

join(1)

EXAMPLES

The following command line joins the password ®le and the group ®le, matching on the numeric group ID, and outputting the login name, the group name, and the login directory. It is assumed that the ®les have been sorted in the collating sequence de®ned by the LC_COLLATE or LANG environment variable on the group ID ®elds.

join -1 4 -2 3 -o 1.1 2.1 1.6 -t: /etc/passwd /etc/group

The following command produces an output consisting all possible combinations of lines that have identical ®rst ®elds in the two sorted ®les sf1 and sf2, with each line consisting of the ®rst and third ®elds from sorted_file1 and the second and fourth ®elds from sorted_file2 :

join -j1 1 -j2 1 -o 1.1,2.2,1.3,2.4 sorted_file1 sorted_file2

WARNINGS

With default ®eld separation, the collating sequence is that of sort -b; with -t, the sequence is that of a plain sort.

The conventions of join, sort, comm, uniq, and awk are incongruous.

Numeric ®lenames may cause con¯ict when the -ooption is used immediately before listing ®lenames.

AUTHOR

join was developed by OSF and HP.

SEE ALSO

awk(1), comm(1), sort(1), uniq(1).

STANDARDS CONFORMANCE

join: SVID2, SVID3, XPG2, XPG3, XPG4, POSIX.2

j

HP-UX Release 11i: December 2000

− 2 −

Section 1−365