Joshua D. Drake wrote:
>>
>> And, BTW, I deal with CSV *all the time* for my insurance clients,
>> and I can tell you that that format hasn't changed in 20 years. We
>> can hard-code it if it's easier.
>
>
> Well many of my clients consider CSV "Character Separated Value" not
> Comma... Thus I get data like this:
>
> "Hello","Good Bye"
> Hello Good Bye
> Hello,Good Bye
> "This", "They're"
> This They're
> "This" "Is" "A" 1
*nod* I too have seen these and other variants over the years, including
some that use single quote instead of double quote as the quote char,
and \ as the escape char.
My suggested scheme for beefing up COPY was made with all these variants
in mind.
cheers
andrew