Re: The " character in CPYFRMIMPF

[rob@xxxxxxxxx]

Toss it to IBM anyway and see if they bite.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





Douglas Handy <dhandy@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
09/29/2004 03:33 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Fax to

Subject
Re: The " character in CPYFRMIMPF






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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.