Re: Translating CSV to Data Structure (or iterating through a data structure)

[Mike Wills <mike@xxxxxxxxxxxx>]

That seems like a lot of I/O for a document with a few hundred lines.
This thought did cross my mind, but the I/O is what caused me pause. I
don't know how many documents a day they will get.

--
Mike Wills
http://mikewills.me



On Tue, May 10, 2011 at 8:56 AM, Alan Shore <ashore@xxxxxxxx> wrote:
> Hi Mike
> Hopefully, this makes some sense
> If you can recognize the format of each record BEFORE parsing, why don't you read the csv file, create a temporary file in QTEMP for that format, and the use the CPYFRMIMPF from that one record file into another file of the correct format
> Saves the headache of trying to write something to parse out the data correctly
>
>
> Alan Shore
> Programmer/Analyst, Direct Response
> E:AShore@xxxxxxxx
> P:(631) 200-5019
> C:(631) 880-8640
> "If you're going through Hell, keep going" - Winston Churchill
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Wills
> Sent: Tuesday, May 10, 2011 9:44 AM
> To: RPG programming on the IBM i / System i
> Subject: Translating CSV to Data Structure (or iterating through a data structure)
>
> I have a document I need to parse where each row is a different format. The document is pipe "|" delimited. Is is possible to write a more generic subprocedure to take each row and a data structure and fill in the data structure? What I am thinking is iterating through each field in the data structure and filling it with the corresponding field from the CSV line that I parse. Is this even possible?
>
> --
> Mike Wills
> http://mikewills.me
> --
> 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.