Midrange News for the IBM i Community

Posted by: clbirk
has no ratings.
Published: 02 Apr 2013
Revised: 04 Apr 2013 - 1540 days ago
Last viewed on: 21 Jun 2017 (2961 views) 

Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.

cpytoimpf Published by: clbirk on 02 Apr 2013 view comments(1)

Return to midrangenews.com home page.
Sort Ascend | Descend


(Sign in to Post a Comment)
Posted by: bobcozzi
Site Admin ****
Comment on: cpytoimpf
Posted: 4 years 2 months 22 days 23 minutes ago
Edited: Thu, 04 Apr, 2013 at 17:27:14 (1540 days ago)

The CPYTOCSV does NOT embed an extra blank.

Maybe your company should purchase Bob's cpytocsv in COZTOOLS or call IBM support and ask them to put that capability into CPYTOIMPF.

The reason they (IBM) does this is because two consecutive "" are considered an escaped quote. So when it is read back in via CPYFRMIMPF it would get confused that "John","", means John followed by an empty field. it would treat it as John followed by a single Quote.

But they've never been more than 10 years behind the rest of the world regarding CSV support so why is it surprising that this is an issue?