-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
| We have clients sending us xls file. | We export them as csv files, using commas or semi-colons. as delimiters and | then make an import in mysql. | Problem : some of the fields, containing texts, have sometimes already a | comma or a semi-colon in them...and when we import, of course MySql thinks | the portion between 2 commas for example is a table field... | | What can we do ? We can't control what the client have typed, neither tell | them "Don't use , or ;" neither ckeck and modify every xls file
Can you not export to a tab delimited file? You should be able to then import that into MySQL. Or if not, replace the tabs with pipes? - -- /* All outgoing email scanned by AVG Antivirus */ Amer Neely, Softouch Information Services Home of Spam Catcher & North Bay Information Technology Networking Group W: www.softouch.on.ca E: [EMAIL PROTECTED] Perl | PHP | MySQL | CGI programming for all data entry forms. "We make web sites work!" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (MingW32) Comment: For info see http://www.gnupg.org
iEYEARECAAYFAkF4b8oACgkQ3RxspxLYVsWQxgCgo+8cAl1icbYRRVPKEDPW98Jd rFQAn0IL9DtKhoOjfV3pyDPGQJzfVHg1 =M04C -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]