Re: CSV file - Using COPY Command - Double-Quotes

On Tue, December 6, 2005 12:01 pm, Walter said:

> All of the values within the CSV are surrounded with quotation marks. So
> a null value for a field looks like ""
>
> I am trying to import the file and no matter what I do, it hits a null
> date field and says
>
> invalid input syntax for type date : ""

sed 's/,"",/,,/g' filename > filename.new

Should do the trick...

(That is: Replace ever occurance of ,"", with ,, in the file 'filename'
and place the result in 'filename.new'. If you aren't on a Unix machine,
you may have to find another tool to do the same.)

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author. Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes. This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------