1 /* join - join lines of two files on a common field
2 Copyright (C) 91, 1995-1999 Free Software Foundation, Inc.
4 This program is free software; you can redistribute it and/or modify
5 it under the terms of the GNU General Public License as published by
6 the Free Software Foundation; either version 2, or (at your option)
9 This program is distributed in the hope that it will be useful,
10 but WITHOUT ANY WARRANTY; without even the implied warranty of
11 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 GNU General Public License for more details.
14 You should have received a copy of the GNU General Public License
15 along with this program; if not, write to the Free Software Foundation,
16 Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
18 Written by Mike Haertel, mike@gnu.ai.mit.edu. */
24 #include <sys/types.h>
29 #include "hard-locale.h"
30 #include "linebuffer.h"
31 #include "memcasecmp.h"
35 /* The official name of this program (e.g., no `g' prefix). */
36 #define PROGRAM_NAME "join"
38 #define AUTHORS "Mike Haertel"
40 #define join system_join
42 /* Undefine, to avoid warning about redefinition on some systems. */
45 #define min(A, B) ((A) < (B) ? (A) : (B))
46 #define max(A, B) ((A) > (B) ? (A) : (B))
48 /* An element of the list identifying which fields to print for each
52 /* File number: 0, 1, or 2. 0 means use the join field.
53 1 means use the first file argument, 2 the second. */
56 /* Field index (zero-based), specified only when FILE is 1 or 2. */
62 /* A field of a line. */
65 const unsigned char *beg
; /* First character in field. */
66 size_t len
; /* The length of the field. */
69 /* A line read from an input file. */
72 struct linebuffer buf
; /* The line itself. */
73 int nfields
; /* Number of elements in `fields'. */
74 int nfields_allocated
; /* Number of elements in `fields'. */
78 /* One or more consecutive lines read from a file that all have the
79 same join field value. */
82 int count
; /* Elements used in `lines'. */
83 int alloc
; /* Elements allocated in `lines'. */
87 /* The name this program was run with. */
91 /* Nonzero if the LC_COLLATE locale is hard. */
92 static int hard_LC_COLLATE
;
95 /* If nonzero, print unpairable lines in file 1 or 2. */
96 static int print_unpairables_1
, print_unpairables_2
;
98 /* If nonzero, print pairable lines. */
99 static int print_pairables
;
101 /* Empty output field filler. */
102 static char *empty_filler
;
104 /* Field to join on. */
105 static int join_field_1
, join_field_2
;
107 /* List of fields to print. */
108 static struct outlist outlist_head
;
110 /* Last element in `outlist', where a new element can be added. */
111 static struct outlist
*outlist_end
= &outlist_head
;
113 /* Tab character separating fields; if this is NUL fields are separated
114 by any nonempty string of white space, otherwise by exactly one
118 /* When using getopt_long_only, no long option can start with
119 a character that is a short option. */
120 static struct option
const longopts
[] =
122 {"ignore-case", no_argument
, NULL
, 'i'},
123 {"j", required_argument
, NULL
, 'j'},
124 {"j1", required_argument
, NULL
, '1'},
125 {"j2", required_argument
, NULL
, '2'},
126 {GETOPT_HELP_OPTION_DECL
},
127 {GETOPT_VERSION_OPTION_DECL
},
131 /* Used to print non-joining lines */
132 static struct line uni_blank
;
134 /* If nonzero, ignore case when comparing join fields. */
135 static int ignore_case
;
141 fprintf (stderr
, _("Try `%s --help' for more information.\n"),
146 Usage: %s [OPTION]... FILE1 FILE2\n\
150 For each pair of input lines with identical join fields, write a line to\n\
151 standard output. The default join field is the first, delimited\n\
152 by whitespace. When FILE1 or FILE2 (not both) is -, read standard input.\n\
154 -a SIDE print unpairable lines coming from file SIDE\n\
155 -e EMPTY replace missing input fields with EMPTY\n\
156 -i, --ignore-case ignore differences in case when comparing fields\n\
157 -j FIELD (obsolescent) equivalent to `-1 FIELD -2 FIELD'\n\
158 -j1 FIELD (obsolescent) equivalent to `-1 FIELD'\n\
159 -j2 FIELD (obsolescent) equivalent to `-2 FIELD'\n\
160 -o FORMAT obey FORMAT while constructing output line\n\
161 -t CHAR use CHAR as input and output field separator\n\
162 -v SIDE like -a SIDE, but suppress joined output lines\n\
163 -1 FIELD join on this FIELD of file 1\n\
164 -2 FIELD join on this FIELD of file 2\n\
165 --help display this help and exit\n\
166 --version output version information and exit\n\
168 Unless -t CHAR is given, leading blanks separate fields and are ignored,\n\
169 else fields are separated by CHAR. Any FIELD is a field number counted\n\
170 from 1. FORMAT is one or more comma or blank separated specifications,\n\
171 each being `SIDE.FIELD' or `0'. Default FORMAT outputs the join field,\n\
172 the remaining fields from FILE1, the remaining fields from FILE2, all\n\
173 separated by CHAR.\n\
175 puts (_("\nReport bugs to <bug-textutils@gnu.org>."));
177 exit (status
== 0 ? EXIT_SUCCESS
: EXIT_FAILURE
);
181 ADD_FIELD (struct line
*line
, const unsigned char *field
, size_t len
)
183 if (line
->nfields
>= line
->nfields_allocated
)
185 line
->nfields_allocated
= (3 * line
->nfields_allocated
) / 2 + 1;
186 line
->fields
= (struct field
*) xrealloc ((char *) line
->fields
,
187 (line
->nfields_allocated
188 * sizeof (struct field
)));
190 line
->fields
[line
->nfields
].beg
= field
;
191 line
->fields
[line
->nfields
].len
= len
;
195 /* Fill in the `fields' structure in LINE. */
198 xfields (struct line
*line
)
201 unsigned char *ptr0
= (unsigned char *) line
->buf
.buffer
;
206 lim
= ptr0
+ line
->buf
.length
- 1;
210 /* Skip leading blanks before the first field. */
211 while (ptr
< lim
&& ISBLANK (*ptr
))
215 for (i
= 0; ptr
< lim
; ++i
)
222 while (ptr
< lim
&& *ptr
!= tab
)
224 ADD_FIELD (line
, beg
, ptr
- beg
);
233 while (ptr
< lim
&& !ISBLANK (*ptr
))
235 ADD_FIELD (line
, beg
, ptr
- beg
);
236 while (ptr
< lim
&& ISBLANK (*ptr
))
241 if (ptr
!= ptr0
&& ((!tab
&& ISBLANK (ptr
[-1])) || ptr
[-1] == tab
))
243 /* Add one more (empty) field because the last character of the
244 line was a delimiter. */
245 ADD_FIELD (line
, NULL
, 0);
249 /* Read a line from FP into LINE and split it into fields.
250 Return 0 if EOF, 1 otherwise. */
253 get_line (FILE *fp
, struct line
*line
)
255 initbuffer (&line
->buf
);
257 if (! readline (&line
->buf
, fp
))
259 free (line
->buf
.buffer
);
260 line
->buf
.buffer
= NULL
;
264 line
->nfields_allocated
= 0;
272 freeline (struct line
*line
)
274 free ((char *) line
->fields
);
275 free (line
->buf
.buffer
);
276 line
->buf
.buffer
= NULL
;
280 initseq (struct seq
*seq
)
284 seq
->lines
= (struct line
*) xmalloc (seq
->alloc
* sizeof (struct line
));
287 /* Read a line from FP and add it to SEQ. Return 0 if EOF, 1 otherwise. */
290 getseq (FILE *fp
, struct seq
*seq
)
292 if (seq
->count
== seq
->alloc
)
295 seq
->lines
= (struct line
*)
296 xrealloc ((char *) seq
->lines
, seq
->alloc
* sizeof (struct line
));
299 if (get_line (fp
, &seq
->lines
[seq
->count
]))
308 delseq (struct seq
*seq
)
311 for (i
= 0; i
< seq
->count
; i
++)
312 if (seq
->lines
[i
].buf
.buffer
)
313 freeline (&seq
->lines
[i
]);
314 free ((char *) seq
->lines
);
317 /* Return <0 if the join field in LINE1 compares less than the one in LINE2;
318 >0 if it compares greater; 0 if it compares equal. */
321 keycmp (struct line
*line1
, struct line
*line2
)
323 /* Start of field to compare in each file. */
324 const unsigned char *beg1
, *beg2
;
326 int len1
, len2
; /* Length of fields to compare. */
329 if (join_field_1
< line1
->nfields
)
331 beg1
= line1
->fields
[join_field_1
].beg
;
332 len1
= line1
->fields
[join_field_1
].len
;
340 if (join_field_2
< line2
->nfields
)
342 beg2
= line2
->fields
[join_field_2
].beg
;
343 len2
= line2
->fields
[join_field_2
].len
;
352 return len2
== 0 ? 0 : -1;
356 /* Use an if-statement here rather than a function variable to
357 avoid portability hassles of getting a non-conflicting declaration
361 /* FIXME: ignore_case does not work with NLS (in particular,
362 with multibyte chars). */
363 diff
= memcasecmp (beg1
, beg2
, min (len1
, len2
));
369 return memcoll ((char *) beg1
, len1
, (char *) beg2
, len2
);
371 diff
= memcmp (beg1
, beg2
, min (len1
, len2
));
379 /* Print field N of LINE if it exists and is nonempty, otherwise
380 `empty_filler' if it is nonempty. */
383 prfield (int n
, struct line
*line
)
387 if (n
< line
->nfields
)
389 len
= line
->fields
[n
].len
;
391 fwrite (line
->fields
[n
].beg
, 1, len
, stdout
);
392 else if (empty_filler
)
393 fputs (empty_filler
, stdout
);
395 else if (empty_filler
)
396 fputs (empty_filler
, stdout
);
399 /* Print the join of LINE1 and LINE2. */
402 prjoin (struct line
*line1
, struct line
*line2
)
404 const struct outlist
*outlist
;
406 outlist
= outlist_head
.next
;
409 const struct outlist
*o
;
419 if (line1
== &uni_blank
)
422 field
= join_field_2
;
427 field
= join_field_1
;
432 line
= (o
->file
== 1 ? line1
: line2
);
433 assert (o
->field
>= 0);
436 prfield (field
, line
);
440 putchar (tab
? tab
: ' ');
448 if (line1
== &uni_blank
)
455 prfield (join_field_1
, line1
);
456 for (i
= 0; i
< join_field_1
&& i
< line1
->nfields
; ++i
)
458 putchar (tab
? tab
: ' ');
461 for (i
= join_field_1
+ 1; i
< line1
->nfields
; ++i
)
463 putchar (tab
? tab
: ' ');
467 for (i
= 0; i
< join_field_2
&& i
< line2
->nfields
; ++i
)
469 putchar (tab
? tab
: ' ');
472 for (i
= join_field_2
+ 1; i
< line2
->nfields
; ++i
)
474 putchar (tab
? tab
: ' ');
481 /* Print the join of the files in FP1 and FP2. */
484 join (FILE *fp1
, FILE *fp2
)
486 struct seq seq1
, seq2
;
488 int diff
, i
, j
, eof1
, eof2
;
490 /* Read the first line of each file. */
496 while (seq1
.count
&& seq2
.count
)
498 diff
= keycmp (&seq1
.lines
[0], &seq2
.lines
[0]);
501 if (print_unpairables_1
)
502 prjoin (&seq1
.lines
[0], &uni_blank
);
503 freeline (&seq1
.lines
[0]);
510 if (print_unpairables_2
)
511 prjoin (&uni_blank
, &seq2
.lines
[0]);
512 freeline (&seq2
.lines
[0]);
518 /* Keep reading lines from file1 as long as they continue to
519 match the current line from file2. */
522 if (!getseq (fp1
, &seq1
))
528 while (!keycmp (&seq1
.lines
[seq1
.count
- 1], &seq2
.lines
[0]));
530 /* Keep reading lines from file2 as long as they continue to
531 match the current line from file1. */
534 if (!getseq (fp2
, &seq2
))
540 while (!keycmp (&seq1
.lines
[0], &seq2
.lines
[seq2
.count
- 1]));
544 for (i
= 0; i
< seq1
.count
- 1; ++i
)
545 for (j
= 0; j
< seq2
.count
- 1; ++j
)
546 prjoin (&seq1
.lines
[i
], &seq2
.lines
[j
]);
549 for (i
= 0; i
< seq1
.count
- 1; ++i
)
550 freeline (&seq1
.lines
[i
]);
553 seq1
.lines
[0] = seq1
.lines
[seq1
.count
- 1];
559 for (i
= 0; i
< seq2
.count
- 1; ++i
)
560 freeline (&seq2
.lines
[i
]);
563 seq2
.lines
[0] = seq2
.lines
[seq2
.count
- 1];
570 if (print_unpairables_1
&& seq1
.count
)
572 prjoin (&seq1
.lines
[0], &uni_blank
);
573 freeline (&seq1
.lines
[0]);
574 while (get_line (fp1
, &line
))
576 prjoin (&line
, &uni_blank
);
581 if (print_unpairables_2
&& seq2
.count
)
583 prjoin (&uni_blank
, &seq2
.lines
[0]);
584 freeline (&seq2
.lines
[0]);
585 while (get_line (fp2
, &line
))
587 prjoin (&uni_blank
, &line
);
596 /* Add a field spec for field FIELD of file FILE to `outlist'. */
599 add_field (int file
, int field
)
603 assert (file
== 0 || file
== 1 || file
== 2);
604 assert (file
== 0 ? field
< 0 : field
>= 0);
606 o
= (struct outlist
*) xmalloc (sizeof (struct outlist
));
611 /* Add to the end of the list so the fields are in the right order. */
612 outlist_end
->next
= o
;
616 /* Convert a single field specifier string, S, to a *FILE_INDEX, *FIELD_INDEX
617 pair. In S, the field index string is 1-based; *FIELD_INDEX is zero-based.
618 If S is valid, return zero. Otherwise, give a diagnostic, don't update
619 *FILE_INDEX or *FIELD_INDEX, and return nonzero. */
622 decode_field_spec (const char *s
, int *file_index
, int *field_index
)
626 /* The first character must be 0, 1, or 2. */
633 /* Give *field_index an invalid value. */
639 /* `0' must be all alone -- no `.FIELD'. */
640 error (0, 0, _("invalid field specifier: `%s'"), s
);
646 if (s
[1] == '.' && s
[2] != '\0')
651 s_err
= xstrtol (s
+ 2, NULL
, 10, &tmp_long
, "");
652 if (s_err
!= LONGINT_OK
|| tmp_long
<= 0 || tmp_long
> INT_MAX
)
654 error (0, 0, _("invalid field number: `%s'"), s
+ 2);
658 *file_index
= s
[0] - '0';
659 /* Convert to a zero-based index. */
660 *field_index
= (int) tmp_long
- 1;
667 error (0, 0, _("invalid file number in field spec: `%s'"), s
);
673 /* Add the comma or blank separated field spec(s) in STR to `outlist'.
674 Return nonzero to indicate failure. */
677 add_field_list (const char *c_str
)
681 /* Make a writable copy of c_str. */
682 str
= (char *) alloca (strlen (c_str
) + 1);
689 int file_index
, field_index
;
692 p
= strpbrk (p
, ", \t");
695 invalid
= decode_field_spec (spec_item
, &file_index
, &field_index
);
698 add_field (file_index
, field_index
);
699 uni_blank
.nfields
= max (uni_blank
.nfields
, field_index
);
705 /* Create a blank line with COUNT fields separated by tabs. */
708 make_blank (struct line
*blank
, int count
)
712 struct field
*fields
;
713 blank
->nfields
= count
;
714 blank
->buf
.size
= blank
->buf
.length
= count
+ 1;
715 blank
->buf
.buffer
= buffer
= xmalloc (blank
->buf
.size
);
716 blank
->fields
= fields
=
717 (struct field
*) xmalloc (sizeof (struct field
) * count
);
718 for (i
= 0; i
< count
; i
++)
721 fields
[i
].beg
= &buffer
[i
];
728 main (int argc
, char **argv
)
732 int optc
, prev_optc
= 0, nfiles
;
734 program_name
= argv
[0];
735 setlocale (LC_ALL
, "");
736 bindtextdomain (PACKAGE
, LOCALEDIR
);
737 textdomain (PACKAGE
);
740 hard_LC_COLLATE
= hard_locale (LC_COLLATE
);
743 /* Initialize this before parsing options. In parsing options,
744 it may be increased. */
745 uni_blank
.nfields
= 1;
750 while ((optc
= getopt_long_only (argc
, argv
, "-a:e:i1:2:o:t:v:", longopts
,
765 if (xstrtol (optarg
, NULL
, 10, &val
, "") != LONGINT_OK
766 || (val
!= 1 && val
!= 2))
767 error (EXIT_FAILURE
, 0, _("invalid field number: `%s'"), optarg
);
769 print_unpairables_1
= 1;
771 print_unpairables_2
= 1;
775 empty_filler
= optarg
;
783 if (xstrtol (optarg
, NULL
, 10, &val
, "") != LONGINT_OK
784 || val
<= 0 || val
> INT_MAX
)
786 error (EXIT_FAILURE
, 0,
787 _("invalid field number for file 1: `%s'"), optarg
);
789 join_field_1
= (int) val
- 1;
793 if (xstrtol (optarg
, NULL
, 10, &val
, "") != LONGINT_OK
794 || val
<= 0 || val
> INT_MAX
)
795 error (EXIT_FAILURE
, 0,
796 _("invalid field number for file 2: `%s'"), optarg
);
797 join_field_2
= (int) val
- 1;
801 if (xstrtol (optarg
, NULL
, 10, &val
, "") != LONGINT_OK
802 || val
<= 0 || val
> INT_MAX
)
803 error (EXIT_FAILURE
, 0, _("invalid field number: `%s'"), optarg
);
804 join_field_1
= join_field_2
= (int) val
- 1;
808 if (add_field_list (optarg
))
816 case 1: /* Non-option argument. */
817 if (prev_optc
== 'o' && optind
<= argc
- 2)
819 if (add_field_list (optarg
))
822 /* Might be continuation of args to -o. */
823 continue; /* Don't change `prev_optc'. */
828 error (0, 0, _("too many non-option arguments"));
831 names
[nfiles
++] = optarg
;
834 case_GETOPT_HELP_CHAR
;
836 case_GETOPT_VERSION_CHAR (PROGRAM_NAME
, AUTHORS
);
844 /* Now that we've seen the options, we can construct the blank line
846 make_blank (&uni_blank
, uni_blank
.nfields
);
850 error (0, 0, _("too few non-option arguments"));
854 fp1
= STREQ (names
[0], "-") ? stdin
: fopen (names
[0], "r");
856 error (EXIT_FAILURE
, errno
, "%s", names
[0]);
857 fp2
= STREQ (names
[1], "-") ? stdin
: fopen (names
[1], "r");
859 error (EXIT_FAILURE
, errno
, "%s", names
[1]);
861 error (EXIT_FAILURE
, errno
, _("both files cannot be standard input"));
864 if (fp1
!= stdin
&& fclose (fp1
) == EOF
)
865 error (EXIT_FAILURE
, errno
, "%s", names
[0]);
866 if (fp2
!= stdin
&& fclose (fp2
) == EOF
)
867 error (EXIT_FAILURE
, errno
, "%s", names
[1]);
868 if ((fp1
== stdin
|| fp2
== stdin
) && fclose (stdin
) == EOF
)
869 error (EXIT_FAILURE
, errno
, "-");
870 if (ferror (stdout
) || fclose (stdout
) == EOF
)
871 error (EXIT_FAILURE
, errno
, _("write error"));