My thanks to John Venier who came up with the answer, it appears that the
files have to be sorted on the field you're going to 'join' on.
-----Original Message-----
From: John Venier [mailto:venier_at_odin.mdacc.tmc.edu]
Sent: Friday, February 02, 2001 1:34 PM
To: Gary.Wermerskirchen_at_trizetto.com
Subject: Re: Trying to 'join' two files
Hi Gary,
Wermerskirchen, Gary sent the following indented text:
>
> O.K. wizards, gurus, etc., I'm stuck and I can't see what I'm missing. I'm
> attempting to 'join' two files, with a common field and it only joins up
the
> first two lines. I deleted the second line of each file and then it joined
> on the 1st, 3rd and last lines.
>
> I then went a step farther and copied file #1 to file #2, so they're
> identical, that too only displays the first two lines. What am I missing?
Is
> a special character in this file that is causing it to fail? I've even
> looked at hex dumps of both files to verify there isn't a nonprintable
> character in the files.
>
> Thanks in advance, I'll summarize once I learn what I've missed,
Don't both files have to be sorted on the join field, which in this
case would be the first field?
That might explain it. It certainly is consistent with what you report.
John
--
John Jeffrey Venier, M.Stat. Programmer Analyst III
Section of Computer Science Department of Biomathematics
The University of Texas M. D. Anderson Cancer Center, Houston, Texas
venier_at_mdanderson.org +1 713 792 2622
Received on Fri Feb 02 2001 - 20:57:16 NZDT