Re: Parse a CSV format record with embedded double quote

First: The CSV file is created from EXCEL.
Second: Since the user can enter anything they want in an EXCEL column, I
need to verify that the data is within the correct length and also the
correct format.
I have found Scott Klements' CSVR4 programs and have decided to use them to
parse my data as he already has the logic to handle this condition.

Jeff Young
Sr. Programmer Analyst

On Wed, Aug 30, 2017 at 2:21 PM, John Yeung <gallium.arsenide@xxxxxxxxx>
wrote:

On Wed, Aug 30, 2017 at 11:50 AM, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

I am reading the CSV file directly from the IFS and parsing the data in

my

program.
I need to be able to properly parse the fields so that I can edit them.
I can not just use CPYFRMIMPF as the data may not always be in the

correct

format.

In what way do you mean "not in the correct format"? Invalid CSV, such
as mismatched or inconsistent use of delimiters? Or valid CSV but not
the expected types/sizes of data?

John Y.
--
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: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://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