Warning: main(/www/www/htdocs/style/globals.php) [function.main]: failed to open stream: No such file or directory in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 1
Warning: main() [function.include]: Failed opening '/www/www/htdocs/style/globals.php' for inclusion (include_path='.:/www/www/common:/www/www/php/lib/php') in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 1
Warning: main(/www/www/htdocs/style/header.php) [function.main]: failed to open stream: No such file or directory in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 8
Warning: main() [function.include]: Failed opening '/www/www/htdocs/style/header.php' for inclusion (include_path='.:/www/www/common:/www/www/php/lib/php') in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 8
Merge sorted files (POSIX)
join [-1 n] [-2 n]
[-a file_number] [-e string]
[-j file_number n]
[-o list] [-t char] [-v file_number]
file1 file2
Neutrino
Options -a, -j, and -v
use the file_number argument. Specify 1
to refer to file1, or 2 to refer to
file2.
- -1 n
- (One) Join on the nth field of
file1. Fields are numbered, starting with 1.
- -2 n
- Join on the nth field of
file2. Fields are numbered, starting with 1.
- -a file_number
- In addition to the default output, produce a line for every unpairable
line in file file_number. If both
-a 1 and -a 2 are specified, both sets
of information are output, and information for -a 2 is
always printed first.
- -e string
- Replace empty output fields by the string string.
- -j file_number n
- (Obsolescent) Join on the nth field of file
file_number. If file_number
is neither 1 nor 2 (e.g.
-j 0 3), use the nth field in
both files. Fields are numbered, starting with 1.
Use options -1 and
-2 in place of option -j.
- -o list
- Produce output in which each line comprises the fields specified in
list. Each entry in list
has the form:
file_number.field
where field is a field number.
You can use a space or a comma to separate entries.
Output is written only for lines with matching join fields. The join
field isn't written unless it's included in list.
- -t char
- Use the character char as a separator, for both
input and output. Every appearance of char in a
line is significant. When this option is specified, the collating
sequence should be the same as that produced by
sort,
without the -b option.
- -v file_number
- Instead of the default output, produce a line only for every unpairable
line in file_number.
- file1 file2
- The names of the text files. If either file1
or file2 is -, the standard
input is used.
The join utility forms a “join” of the two relations
specified by the lines of file1 and
file2. The join is written to the standard output.
The files file1 and file2 are
compared on the basis of a “join field” found in both files. For every pair of
lines in file1 and file2 that
have identical join fields, join prints one output line. The
output line normally consists of the join field, followed by the rest of the
line from file1 and then the rest of the line from
file2. By default, the join field is the first field
in each line.
Both file1 and file2 should
be sorted in an increasing collating sequence on their join fields
(i.e. the same sequence performed by
sort -b).
Otherwise, some field matches
may not be reported. Note, however, that when option -t is
specified, the collating sequence should be the same as that produced by
sort, without the -b option.
The default input field separators are blanks. In this
case, multiple separators count as one field separator; leading separators
are ignored. The default output field separator is a space.
Join the password file and group file, matching on the numeric group
ID and outputting the login name, group name, and login directory.
It's assumed that the files have been sorted in collating sequence
on the group ID fields.
join -1 4 -2 3 -o 1.1 2.1 1.6 -t: /etc/passwd /etc/group
- 0
- All input files were output successfully.
- >0
- An error occurred.
gawk,
sort,
uniq
Warning: main(/www/www/htdocs/style/footer.php) [function.main]: failed to open stream: No such file or directory in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 187
Warning: main() [function.include]: Failed opening '/www/www/htdocs/style/footer.php' for inclusion (include_path='.:/www/www/common:/www/www/php/lib/php') in /www/www/docs/6.4.1/neutrino/utilities/j/join.html on line 187