Re: Ignoring carriage returns from data field
| From: | Curt Zirzow | Date: | Fri, 13 Aug 2004 19:31:34 +0000 |
| Subject: | Re: Ignoring carriage returns from data field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-193748@lists.php.net to get a copy of this message | ||
* Thus wrote Vern:
> 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?
if a field contains [",\n\r\t] the field must be quoted. and quotes
inside are double quoted:
field,"field ""with quotes""","or, with a comma", "and
a carriage return",field4
Curt
--
First, let me assure you that this is not one of those shady pyramid schemes
you've been hearing about. No, sir. Our model is the trapezoid!