From: | Guy Fraser <guy(at)incentre(dot)net> |
---|---|
To: | pgsql-sql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: CSV import |
Date: | 2003-02-01 01:32:08 |
Message-ID: | 3E3B2398.1010101@incentre.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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...
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew J. Kopciuch | 2003-02-01 02:36:17 | Re: [SQL] For each record in SELECT |
Previous Message | Keary Suska | 2003-02-01 01:28:34 | Re: For each record in SELECT |