you could also delimit the fields by tab spaces (tab delimited) use google...
-----Original Message----- From: dwight ian [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 17, 2004 8:16 AM To: [EMAIL PROTECTED] Subject: [PHP-WIN] HELP CSV's Good day to you All, Hi Im working on a project where it is nessary to download the values of the tables in the database and format them in csv (comma separated values) files in order for them to be viewed in a spreadsheet application (ie Microsoft Excel). The problem happens when the values in the tables includes commas and new line, it disrupts the csv file. What will I do?, Please help. Lycos recommends Cheapflights for all your travel needs. Go to http://www.cheapflights.co.uk/?source=lycosgen -------------------------------------------------------------------- Disclaimer This e-mail transmission contains confidential information, which is the property of the sender. The information in this e-mail or attachments thereto is intended for the attention and use only of the addressee. Should you have received this e-mail in error, please delete and destroy it and any attachments thereto immediately. Under no circumstances will the Cape Technikon or the sender of this e-mail be liable to any party for any direct, indirect, special or other consequential damages for any use of this e-mail. For the detailed e-mail disclaimer please refer to http://www.ctech.ac.za/polic or call +27 (0)21 460 3911 -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php