Re: The " character in CPYFRMIMPF

[Douglas Handy <dhandy@xxxxxxxxx>]

Rob,

> Perhaps so, but a bugs a bug and I still recommend reporting it to IBM.

I don't think I can call this a bug.  There are no well-defined
industry standards for CSV formatting.  That is why MS can get by with
Excel's abhorent behavior of having any value which looks like a
number be construed as a number even when it is in quotes.  This
absolutely wrecks havoc with trying to import USA 5-digit zip codes
when using CSV extensions.

I believe both Excel and CPYFRMIMPF will handle consecutive (i.e.
doubled) quote as in "15"" PIZZA", much like you'd say 'o''clock' in a
RPG literal.  I'd argue that the CSV contents is faulty, even if Excel
will accept it.

Doug