X-Original-To: pgsql-sql@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 14D5A479BB5
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 21:15:23 -0500 (EST)
Received: from bach.ccinet.ab.ca (bach.ccinet.ab.ca [198.161.96.1])
	by postgresql.org (Postfix) with ESMTP id 5F67D4791C9
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 20:32:15 -0500 (EST)
Received: from incentre.net (squid.incentre.net [206.75.213.195])
	by bach.ccinet.ab.ca (8.12.6/8.12.6) with ESMTP id h111bBUs079186
	for <pgsql-sql@postgresql.org>; Fri, 31 Jan 2003 18:37:12 -0700 (MST)
	(envelope-from guy@incentre.net)
Message-ID: <3E3B2398.1010101@incentre.net>
Date: Fri, 31 Jan 2003 18:32:08 -0700
From: Guy Fraser <guy@incentre.net>
Organization: J I Reasearch
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: CSV import
References: <3E3697AF.2030509@aon.at> <3E370095.3020200@incentre.net>
	<3E373369.52C862DE@nsd.ca> <013601c2c8a0$f6ca2280$32021aac@chad>
	<3E3A95F3.842C9691@nsd.ca>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200301/528
X-Sequence-Number: 11393

FYI

In text files on a Mac. the EOL character is a <CR> only.

What a messy thing this whole EOL cruft is.

To convert between these text formats on linux is easy if you have dos2unix.

The dos2unix on linux can perform many format conversions to and from unix,dos 
and mac formats.

On BSD you need dos2unix to convert from dos to unix and unix2dos to convert 
from unix to dos. You probably need to get the GNU version of dos2unix or 
mac2unix to convert to or from mac formatted text.


Guy

Jean-Luc Lachance wrote:
> In DOS and Windows, text lines end with <CR><LF>.
> In Unix, text lines end with <LF> only.
> 
>                 hex   dec    oct
> <CR>=CTRL-M or 0x0D or 13 or 015
> <LF>=CTRL-J or 0x0A or 10 or 012
> 
> 
> 
> Chad Thompson wrote:
> 
>>>Unix EOL is LF not CR.
>>>
>>>
>>
>>Is this the only difference between a dos and unix text file?
>>
>>Thanks
>>Chad
---%<...snip...