PHP to Excel (csv)
| From: | Ivo Stoykov | Date: | Tue, 08 Oct 2002 06:13:42 +0000 |
| Subject: | PHP to Excel (csv) | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-119214@lists.php.net to get a copy of this message | ||
Hi
I have following problem.
Some data retreived from mysql db I need to send to the user as a *.csv
file. Usually I separate fields (usually double quoted) with comma (,) or
semicolomn (;) and the records with cr/lf (Windows)
It works fin until I do not have cr/lf in any of the fields.
Unfortunately the last field is TEXT type and may have more that one cr/lf
inside (as data). When this is the case the *,csv file cannot be open
correctly in Excel. If there are cr/lf in any field it is split in Excel as
a separate row and the record structure is broken.\
Any idea how could solve this? Thank you
Ivo