Re: Spreadsheet_Excel_Reader problem
| From: | Ashley Sheridan | Date: | Thu, 18 Mar 2010 11:55:24 +0000 |
| Subject: | Re: Spreadsheet_Excel_Reader problem | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-302953@lists.php.net to get a copy of this message | ||
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