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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
