question on commas in csv file

[nate100]

Say if I have the following code:

address1 = "Main,St".
address = "First Avenue".

output to "test.csv".

put unformatted address1 "," address2 skip.

output close.

if either address1 or address2 have commas in them, then the columns will not align properly in the csv file. How can I get around this with still have the "," as a delimiter?

Thanks

 

[GregTomkins]

There's this awesome thing called Google...

http://www.csvreader.com/csv_format.php

"# Fields containing a comma must be escaped.

* Excel escapes these values by embedding the field inside a set of double quotes, generally referred to as text qualifiers, i.e. a single cell with the text apples, carrots, and oranges becomes "apples, carrots, and oranges"."