Re: Spreadsheet_Excel_Reader problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux