PHP to Excel (csv)

From: 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

« previous php.general (#119214) next »