Jonathan Hseu wrote:
> I want to import a table from a file. The format of the table in the file is as
> such:
> "FName","LName","Address","City"
>
> The format of the table is:
> (FName varchar(80), LName varchar(80), Address varchar(80), City varchar(80))
>
> I want to do a:
> COPY table FROM 'filename' USING DELIMITERS ','
>
> The problem is, it also imports the quotes. Also, there are sometimes commas in
> the address, and it takes those as delimiters. Is there any way to make it take
> only the stuff within the quotes and ignore any delimiters within them?
>
> Jonathan Hseu
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
reformat such input using sed:
cat yourfile | sed -e 's/"/'\''/g' >yournewfile
For readability : sed -e sq/dq/sq\sqsq/gsq in which sq = single quote dq = double
quote
Vi using regexps is also a good one.
or using perl:
while (<STDIN>) {
chomp();
s/"/'/g;
print $_, "\n";
}
Feite Brekeveld