* 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!

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to