Re: Converting tab delimited file to CSV
| From: | Andrew Ballard | Date: | Mon, 18 Feb 2008 15:15:15 +0000 |
| Subject: | Re: Converting tab delimited file to CSV | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-269479@lists.php.net to get a copy of this message | ||
On Feb 18, 2008 8:58 AM, Edward Kay <edward@labhut.com> wrote:
>
> > Now, I can replace the tabs with commas and opening the resulting
> > files in a basic text editor all looks fine.
>
> When you do this, ensure you escape any commas that may exist in the data.
>
> IIRC, Excel handles this be enclosing the whole field in "double quotes".
> Can remember how it handles escaping these though...
>
> Edward
>
>
If there are double quotes inside a quoted string, they are doubled. eg.
"This string contains ""quoted content"" in a CSV format that M$ products
can understand."
Andrew