On October 23, 2007 10:44:51 am you wrote:
> Hi Chuck,
> Do you need those characters in your table? If not I think you will be
> better off preprocessing the data before running copy.
>
> Replacing those " for ' or directly removing them is quite simple if you
> are working in Unix, actually it should be quite simple in any operating
> system.
>
> Regards,
> Fernando

Greetings,

I'm not sure if they are needed because I've never seen a double quote in a 
place name before.  I don't believe they are errors though because there are 
more records that contain them.  As well, some records have single and double 
quotes allowed within a record and this really messes things up.

Any ideas?  Should I consider removing them in favor of a single quote?  If 
so, do you know how to do this with sed or similar?

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to [EMAIL PROTECTED] so that your
       message can get through to the mailing list cleanly

Reply via email to