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

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