* 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