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

[Jeff Young <cooljeff913@xxxxxxxxx>]

Charles,
Unfortunatly, the program that creates the file is putting it out in variable 
format fields delimited by commas.
The problem is that when the data contained in the field contains a comma, I can 
not parse it correctly.

I have informed the user that the description can not have embedded commas.
Since they get the initial data from the i, they have control of that 
information.

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: Charles Wilt <charles.wilt@xxxxxxxxx>
To: RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
Sent: Fri, July 16, 2010 1:52:51 PM
Subject: 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.