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"