Problem with CSV and Commas
807606May 31 2007 — edited May 31 2007Ok 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!!!