Re: Parsing a CSV file with embeded commas in text field

Jeff,

The only way to handle comma's in a CSV file without using quoted
strings would be if the CSV file is really fixed format.

Example
Charles Wilt ,Some town ,Some State
Jeff Young ,Other town , Other State

Not that even though I've seperated the data with comma's, the data
fields are also fixed length. So It'd be easy to set up a DS like so:
d myDS ds qualified
d name 20a
d 1a
d City 20a
d 1a
d State 20a

HTH,
Charles


On Fri, Jul 16, 2010 at 1:17 PM, Jeff Young <cooljeff913@xxxxxxxxx> wrote:

Thanks for that link.
I will be using that method in the future.
Unfortunatly, I have no control over the format of the data as it is output by a
propriatery PC program.
I will inform the user that embedded commas are not permitted in the data, as
they have some control over the input to the program.

Thanks,


Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3









________________________________
From: Michael Smith <msmith@xxxxxxxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Fri, July 16, 2010 12:21:18 PM
Subject: RE: Parsing a CSV file with embeded commas in text field


I have used this article and program to solve this exact problem.
http://systeminetwork.com/article/how-read-csv-file-rpg

Thanks to Scott doing the article and program.

Michael

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On
Behalf Of Jeff Young
Sent: Friday, July 16, 2010 10:00 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: Parsing a CSV file with embeded commas in text field

I am using the GETTOK routine to parse records from a csv file where some of the

character fields have embedded commas.
I seem to recall that this was addressed in the past, but I do not recall how to

do it.
ex: ...,Apples, Red Delicious   88ct,nnnn,nnnn   ....

All help will be appreciated.

Thanks,



Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions
Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical
Solutions Implementer V5R3
--
This is the RPG programming on the IBM i / System i (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.

--
This is the RPG programming on the IBM i / System i (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.
--
This is the RPG programming on the IBM i / System i (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.