RE: CSV files with Byte Over Marks

Thank you Scott! I will give that a try.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Tuesday, June 19, 2018 6:05 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Re: CSV files with Byte Over Marks

Hi Mike,

This CSV utility is coded to be compatible with V4Rx (originally) which did not support CCSIDs in the IFS.  Since 1208 cannot be opened as a codepage, only as a CCSID, you get the conversion error.  It's very easy to fix.

Find this line of code (in the CSVR4 member, under the csv_open subprocedure):

   myCSV.fp = fopen(%trim(peFilename): 'r');

Change it to the following:

   myCSV.fp = fopen(%trim(peFilename): 'r, o_ccsid=0');

This tells it to use CCSID support rather than codepage support, which will fix the conversion error.  Then using a CCSID of 1208 should work fine.

Good luck!


On 6/19/2018 2:12 PM, Soucy, Michael wrote:

Yes, I am using this utility you wrote, running on V7R1 (We will be upgrading soon).

https://www.scottklement.com/csv/

Can you tell me which utility this is, and what the code looks like?

--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L) mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD