Hi Folks,<br /><br />sorry if this is a duplicate post, i've been tryin to find a solution of importing data into
postgresfrom a csv file. The problem is, I have a database which consists of columns which contain newline characters
(macand unix). now when i export these files to a csv format, there are some line breaks (mixed unix and mac) in the
datawhich breaks the copy procedure. <br /><br />I also tried using the script posted in one of the previous posts..<br
clear="all"/><br />#! /usr/bin/perl<br />$inquotes = 0;<br />while (<>){<br /> # Chop the crlf<br /> chop
($_);<br/> chop ($_);<br /><br /> # this first bit goes through and replaces <br /> # all the commas that
renot in quotes with tildes<br /> for ($i=0 ; $i < length($_) ; $i++){<br /> $char=substr($_,$i,1);<br
/> if ($char eq '"' ){<br /> $inquotes = not($inquotes); <br /> }else{<br /> if
((!$inquotes) && ($char eq ",") ){<br /> substr($_,$i,1)="~";<br /> }<br />
}<br/> }<br /> # this replaces any quotes<br /> s/"//g;<br /> print "$_\n";<br />}<br /><br /><br
/>catdata_file | perl scriptname.pl > outputfile.dat<br /><br />and when i run the copy command i get messages like
datamissing for xyz column.<br />any possible hints....... <br /><br />--<br />Thanks,<br />Sumeet