X-Recipient: archive-cygwin AT delorie DOT com
DomainKey-Signature: a=rsa-sha1; c=nofws; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:from:to:references:in-reply-to:subject:date
	:message-id:mime-version:content-type:content-transfer-encoding;
	 q=dns; s=default; b=Cij2PBm4Hyj7lbPbmwTfjD3CvCuJR+zfFTvhM6Ka+lF
	9Q+pJBrpu/I7stjI80loGxB1WgIpWG/31XywcjLz3zON+yaQt56x7ycWFnlt/IOx
	8l87POUyaYSi9FgF23Ecee3QMMoiZ9UpTkpDkbnz+cKbU7ijiDDtIq/p7ooLVqkY
	=
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=sourceware.org; h=list-id
	:list-unsubscribe:list-subscribe:list-archive:list-post
	:list-help:sender:from:to:references:in-reply-to:subject:date
	:message-id:mime-version:content-type:content-transfer-encoding;
	 s=default; bh=o2jaJ4YDkip4N0XpyoWnuUwa5UE=; b=KgRjKxs8dPMKQAP9c
	qbWH1j6/u3dpBrmJIve5WlYZ3aLspyAAW+PlfeDFx3bTOyG6DttVSubGOU8vxxOu
	SQs/xVYRo4mCetBqwzYUrbaOD0PBzi93bRvMX0D4TZTGz7XjNIHvCOa+Ks9gXBwe
	rJkMO4qXWiEKOOLzMth25jQGk4=
Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Id: <cygwin.cygwin.com>
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Authentication-Results: sourceware.org; auth=none
X-Spam-SWARE-Status: No, score=-1.1 required=5.0 tests=AWL,BAYES_00,FREEMAIL_FROM,RCVD_IN_DNSWL_LOW,SPF_PASS autolearn=ham version=3.3.1 spammy=Eliot, Moss, moss, eliot
X-HELO: resqmta-po-02v.sys.comcast.net
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=comcast.net;	s=20190202a; t=1563894943;	bh=KuUsi1m8jLVVL1eCmLyfejuBDoFdtB7Yi5s/Vlsb7/A=;	h=Received:Received:From:To:Subject:Date:Message-ID:MIME-Version:	 Content-Type;	b=4KKVZI4JwWnaJ0L5T+I61Somdt5a5DrJvOPpZUSRUQoomU6oaobSGLQSBQZJnCUYb	 D7G2a9yFaOx6xoL/WjrV1AKA0xjgvKRwBeDb29iiRxqPnQWrn1KAYUZJzv7jJlQWyT	 7jJ2lGkAN2LoJvnU8xJkRNQIFbOlC/jZDq1WKA1NbhGUCJYFNmBC4pT/ac/5Lpix+R	 9KhsJbG6Wboj7sZnVClF9sqMLw3NlN9O/ydQ3BDULs+y9GBD5ZTx4xvptau5pAef2u	 D45Yrb/2WyTBrvXu13BMOfi5ZRqKKvGK5DN5spBHB0O+XDQ42UXZ6FPxEYDJTYmY5J	 19HcHe2dwAx6w==
X-Xfinity-VAAS: gggruggvucftvghtrhhoucdtuddrgeduvddrjeekgdekjecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucevohhmtggrshhtqdftvghsihdpqfgfvfdppffquffrtefokffrnecuuegrihhlohhuthemuceftddtnecunecujfgurhephffvfhgjufffkfggtgfgofhtsehtjehgtddvtdejnecuhfhrohhmpedftehnugihucfjrghllhdfuceofhhigihpvghrthhishgvqdgtohhnshhulhhtihhnghestghomhgtrghsthdrnhgvtheqnecukfhppeejfedrvddvfedrjeegrddvleenucfrrghrrghmpehhvghloheptehnugihhghorhhkpdhinhgvthepjeefrddvvdefrdejgedrvdelpdhmrghilhhfrhhomhepfhhigihpvghrthhishgvqdgtohhnshhulhhtihhnghestghomhgtrghsthdrnhgvthdprhgtphhtthhopegthihgfihinhestgihghifihhnrdgtohhmpdhrtghpthhtohepmhhoshhssegtshdruhhmrghsshdrvgguuhenucevlhhushhtvghrufhiiigvpedt
X-Xfinity-VMeta: sc=0;st=legit
From: "Andy Hall" <fixpertise-consulting AT comcast DOT net>
To: <moss AT cs DOT umass DOT edu>, <cygwin AT cygwin DOT com>
References: <009e01d540c6$c1b11d50$451357f0$@comcast.net> <ac58e313-bfbf-b245-6c80-58d59be23f47 AT cs DOT umass DOT edu>
In-Reply-To: <ac58e313-bfbf-b245-6c80-58d59be23f47@cs.umass.edu>
Subject: RE: Join command fails to output fields on input file with DOS line endings.
Date: Tue, 23 Jul 2019 08:15:41 -0700
Message-ID: <00a301d54169$7e0a3f70$7a1ebe50$@comcast.net>
MIME-Version: 1.0
Content-Type: text/plain;	charset="utf-8"
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

> On 7/22/2019 12:59 PM, Eliot Moss wrote:
> On 7/22/2019 12:50 PM, Andy Hall wrote:
> > This behavior of join surprised me:
> >
> > $ join -1 3 <(echo a b col3  c d | unix2dos) <(echo col3 f2 f3 f4 f5)
> >   f2 f3 f4 f5
> >
> > Join parses the input line well enough to execute the join, but the presence of the DOS line endings suppresses the
> > output of fields from the first input.
> >
> > Compare with
> >
> > $ join -1 3 <(echo a b col3  c d) <(echo col3 f2 f3 f4 f5)
> > col3 a b c d f2 f3 f4 f5
> >
> > which is correct.
> >
> > Here is a weirder example where the join field is missing and the output is reversed!
> >
> > NOK
> > $ join <(echo col F1 | unix2dos) <(echo col F2)
> >   F2 F1
> >
> > OK
> > $ join <(echo col F1) <(echo col F2)
> > col F1 F2
> 
> The lesson is: You're better off not using DOS line endings with Cygwin.
> It tends to do things the POSIX way, where the line ending is LF, not
> CR LF.  Some things *may* work, but it's somewhat hit or miss ...  EM
> 
Right.  But in this case,  the last field of the first file contains a \r which
completely mangles the output.  

But join appears to "work" if the lines of the second file are in DOS format.

E.g.
$ join <(echo col F1) <(echo col F2 | unix2dos)
col F1 F2


--
Problem reports:       http://cygwin.com/problems.html
FAQ:                   http://cygwin.com/faq/
Documentation:         http://cygwin.com/docs.html
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple