Re: [PHP] Spreadsheet_Excel_Reader problem

On Thu, 2010-03-18 at 12:56 +0100, Jochen Schultz wrote:

> > Microsoft managed to basterdise this format
>  > a bit as well, and lets you use tabs, spaces and all sorts of other
>  > characters to delimit data fields. Someone obviously didn't mention to
>  > them that the file type is 'comma separated values'!
> 
> Or maybe it is because someone told them, that there is data out there, 
> that might contain commas?
> 
> regards
> Jochen


The csv format allows for quote marks which can serve to escape commas:

"data, with commas"

And for escaping quote marks, you just use triple quote marks:

"some text """with quotes""" "

Thanks,
Ash
http://www.ashleysheridan.co.uk