Skip to Main Content

Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem with CSV and Commas

807606May 31 2007 — edited May 31 2007
Ok so I've got this program that will create a CSV file... I'm using the StringBuilder.append function to create the long string that will be viewed in the file..


Now my problem is that one of the values is a Country and City that is separated by a comma..

Example
San Francisco, California

But it is supposed to be treated as a single text so this text should occupy only one cell in excel.. What happens is that it separates them and places it in different cells..

So my question is how does one include this particular comma into the excel file?

Thanks in advance!!!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 28 2007
Added on May 31 2007
10 comments
797 views