Re: [PHP] Spreadsheet_Excel_Reader problem

AFAIK, there is no real standard out there for CSV file definition and 
since Microsoft and many others (me too btw) use other chars for field 
separation in so called CSV files, i think it is a good way to deal with 
it and let it be how it is (actually i have to look into every CSV file 
that is going to be exchanged and that has some advantages as well).

Btw. who told you to use tripple quotes?

http://www.rfc-editor.org/rfc/rfc4180.txt

    7.  If double-quotes are used to enclose fields, then a double-quote
        appearing inside a field must be escaped by preceding it with
        another double quote.  For example:

        "aaa","b""bb","ccc"

regards
Jochen

Ashley Sheridan schrieb:
> 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
> 
>