Re: Parse a CSV format record with embedded double quote

The comma is simple enough, if inside a string field, only look for a
ending double quote.

As far as the embedded double quote, when you're inside the string and you
find a possible ending double, look at the next character. If it's a
double quote also, keep going..

I'd then set a flag so you know that there's an "" that you want to
transform to " in the final string.

Charles

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

All,
I have a CSV format file that contains a field with both a comma (,) and a
double quote (").
Using EXCEL, I have created an example that I use to create that field -
"This, is a test of double quote "" field"

In another program, I take that file and parse the field by using the
double quote as my start and end delimiter to determine how many characters
I need to copy.
With the extra double quotes in the field, how can I determine the correct
position for the end of the field?

TIA

Jeff Young
Sr. Programmer Analyst
--
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