1. Forum
  2. Usenet
  3. COMP.SYS.MAC.PROGRAMMER.M

  • Does Unix join have a limit on the number of lines?

    From Robert Peirce@21:1/5 to Robert Peirce on Sat Jan 30 12:48:07 2021
    On 1/30/21 12:28 PM, Robert Peirce wrote:
    I just discovered a join command I have been using for years stopped
    working on 11/27.  The command is

    join -a1 ~/daily/Input ~/weekly/Input

    What I am trying to do is join the date matched daily and weekly lines
    but include all the daily lines.  The data exists to date but the join
    stops at 11/27.

    The file structures haven't change.  Nothing has changed as far as I can tell.  The output includes all the daily lines but doesn't include any
    of the weekly lines after 11/27.  I have no idea why.

    As a test I tried tailing the last ten lines from each file and joining
    them. That worked. I also tried deleting the first couple of hundred
    lines from the two files. That didn't work. Odd.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Peirce@21:1/5 to All on Sat Jan 30 12:28:55 2021
    I just discovered a join command I have been using for years stopped
    working on 11/27. The command is

    join -a1 ~/daily/Input ~/weekly/Input

    What I am trying to do is join the date matched daily and weekly lines
    but include all the daily lines. The data exists to date but the join
    stops at 11/27.

    The file structures haven't change. Nothing has changed as far as I can
    tell. The output includes all the daily lines but doesn't include any
    of the weekly lines after 11/27. I have no idea why.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Robert Peirce@21:1/5 to All on Sat Jan 30 14:14:35 2021
    On 1/30/21 12:48 PM, Robert Peirce wrote:

    I found the problem. The sort field is yyyy/mm/dd. It turns out in the
    early part of December, 2020, I had entered 2021! I had to do a
    detailed search of every day since the end of November in both files but
    I found it.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)