Re: Parse a CSV format record with embedded double quote

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.

Jeff Young
Sr. Programmer Analyst

On Wed, Aug 30, 2017 at 11:43 AM, Dan <dan27649@xxxxxxxxx> wrote:

On Wed, Aug 30, 2017 at 11:31 AM, Alan Shore <ashore@xxxxxxxx> wrote:

The assumption here is that a field will contain 2 contiguous double

quotes

What happens if the field contains one - or even worse - a number of
non-contiguous double quotes

I hate using comma, single quote or double quote as a delimiter - much
rather use tab - but even THAT is not guaranteed to be with no problems

Exactly. I've even seen that "logical negation symbol" (ASCII 170), and I
can't remember the last time I've seen that on a keyboard. Our app
converts native DB2 data to .csv files we send to our Oracle group, and we
have no control over what is in the original data, which comes to us from
our clients. In particular, we get a "notes" field that CSRs can enter in
anything from the keyboard. I'm not sure why a CSR would ever type three
consecutive double quotes in a note, but I'm in no position to ask, and
CPYTOIMPF resolves the issue so that I don't need to care. CPYTOIMPF
handles this just fine.

- Dan
--
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