Are the quotes necessary?
-----Original Message-----
From: Jon S. Jaques [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 24, 2001 8:35 AM
To: Active Perl List
Subject: Escaping quotes in a CSV file
Hello Group,
I've generated a bunch of CSV files with Perl, but some of the text fields
have quotes in them, and when they are imported to Access/SQL server, the
quotes mess up the fields.
I tried doubling them (the quotes), changing them to singles, etc., but
nothing seems to work. It would seem that I could use "heavier
delimination", or maybe a fixed length format, but then I would also have to
create schema files, which'd be a pain, as I'd have to have the schemas
generated by the script also, in case their format changed.
The one thing that I haven't tried, because I'm trying avoid the dependancy,
is CGI.pm's urlescape method, but I'm not entirely sure that that would
work, either.
Anybody got any ideas??? I'd greatly appreciate it!
TIA,
Jon Jaques
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
_______________________________________________
ActivePerl mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/activeperl
