Generating a .csv file in PHP

[Region, Country]

This is a simple question really...

When generating a .csv file in php, how do you escape commas in sentences or fields. For example, If I want to put Region, Country into one field, how do I stop the csv file from spliting it into two cells? I have tried double and single quotes without any luck.

Thanks

[Join us @ facebook]

You should put it like this :

Code:

"Region, Country"

[SEO Voter]

I have tried that, but it doesn't work...

Also, if I have a paragraph of text, I want to all be in one cell and not spread out over the spreadsheet.

[Join us @ facebook]

Maybe the import program has some kind of bug?

Check this : http://www.ietf.org/rfc/rfc4180.txt

[Join us @ facebook]

Also you can use from mysql the "SELECT INTO OUTFILE" command

[SEO Voter]

Ah, this is what I worked out so far...

There must be no spaces after the commas. For example...

This one is incorrect!

Code:

fwrite ($fd, "$row->data, \"$row->WineryName, $row->CountryName\", $row->BlendName\n");

This one is correct!

Code:

fwrite ($fd, "$row->data,\"$row->WineryName, $row->CountryName\",$row->BlendName\n");

[SEO Voter]

Thanks for the help Nick!

[Join us @ facebook]

Ha.

At least we learned something today. right? (I know this phrase sounds familliar....)

Thanks for the help Nick!

You are welcome

[SEO Voter]

Yes, it is becoming a trend to learn something everyday! LOL

The .csv files I create look like this:

="alpha data , comma's can be used without a problem";123;34;="more text"

be sure to have your list sepperator in 'regional settings' set to ;

[Join us @ facebook]

Even this way you should use "" when you are inserting the ; character.

[Join us @ facebook]

What about reading CSV files?

Is there any cool class/functions that you use for?

[Guest]

[38.670]

Yahoo crawler, Googlebot, Gigabot, Msnbot, Baidu Spider