Quote:
Originally Posted by Farling
In a CSV, the "...." is only required around the items which have embedded commas. For simple columns it shouldn't be required.
|
commas, new lines and quotes actually. You need to embed all of them in quotes actually.
In a CSV file commas mark the end of a column and the new line symbol marks the end of the row. Therefore to include either one in your data you need to wrap it in quotes. Since quotes themselves are treated as a special symbol if you need to include a quotation mark you need to wrap it in quotes as well.
This is why I wrote above that for all but the most trivial CSV files it is far easier to build the file in Excel or some other spreadsheet program and then export it as a CSV rather than trying to build it by hand.