Re: Ignoring carriage returns from data field
| From: | Justin Patrin | Date: | Fri, 13 Aug 2004 20:10:37 +0000 |
| Subject: | Re: Ignoring carriage returns from data field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-193762@lists.php.net to get a copy of this message | ||
On Fri, 13 Aug 2004 14:54:28 -0400, Vern <vernon@comp-wiz.com> wrote:
> I am creating a datadump to a csv file and have noticed that text fields
> that contain carriage returns are causing trouble when opening the csv file
> in an Excel spreadsheet. I'm sure there's a away to ignore those extra
> characters but for the life of me I can't recall what it is. Anyone know how
> this is done?
>
"this field has a comma, and a newline
to show you how quoted fields work", second, third, "fourth field"
--
DB_DataObject_FormBuilder - The database at your fingertips
http://pear.php.net/package/DB_DataObject_FormBuilder
paperCrane --Justin Patrin--