 |
 |
On 11/25/13 1:38 PM, Joe Hourcle wrote: > On Nov 25, 2013, at 1:05 PM, Jonathan Rochkind wrote: > >> Ah, but what if the data itself has tabs! Doh! >> >> It can be a mess either way. There are standards (or conventions?) >> for escaping internal commas in CSV -- which doesn't mean the >> software that was used to produce the CSV, or the software you are >> using to read it, actually respects them. > > You don't have to escape the commas, you just have to double-quote > the string. If you want to have a double quote, you put two in a > row:, eg: > > "He said, ""hello""" Right, I would call that a form of escaping. I can stay blissfully ignorant of what form of escaping is required by CSV and if I'm doing it right by just using a library, heh. Out of curiosity, let's see what the ruby stdlib csv parser/writer writes for various things. Yep, just doublequotes anything with internal commas or quotes. ### ordinary,row,with a value with spaces a row with,"several, internal, commas" or even,"internal ""quotes"", as the kids say"