RE: [PHP] Converting tab delimited file to CSV
| From: | Edward Kay | Date: | Mon, 18 Feb 2008 13:58:33 +0000 |
| Subject: | RE: [PHP] Converting tab delimited file to CSV | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-269475@lists.php.net to get a copy of this message | ||
> Now, I can replace the tabs with commas and opening the resulting
> files in a basic text editor all looks fine.
When you do this, ensure you escape any commas that may exist in the data.
IIRC, Excel handles this be enclosing the whole field in "double quotes".
Can remember how it handles escaping these though...
Edward