On Sat, Dec 15, 2012 at 08:06:44PM +0100, Andreas wrote:
> Hi,
> 
> Problem here is in the morning the first digit of the hour is shown as a 
> blank so there are 2 blanks before the time so COPY misstakes this as an 
> empty column and gets confused.
> 
> Can someone point me in the direction of an COPY option I'm not aware 
> of, or alternativly to some console tool that I can put in the batch 
> before the import step and replace the 2 blanks with 1 blank.
>
> I use an OpenSuse server so some linux tool would do.

A simple sed(1) expression should do the trick:

sed -E 's/ +/ /g' old-file > new-file

GNU sed also allows in-place editing using -i, so you can avoid
writing it to a second file.  Some seds accept a different flag
to enable extended regexps.

Cheers,
Peter
-- 
http://sjamaan.ath.cx
--
"The process of preparing programs for a digital computer
 is especially attractive, not only because it can be economically
 and scientifically rewarding, but also because it can be an aesthetic
 experience much like composing poetry or music."
                                                        -- Donald Knuth


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to