Re: Parsing out a string

Alan

This is what is known as CSV - comma-separated variable - something like that. Can the fields also contain embedded full quotes? That's make it harder.

I can think of a complicated way - write the string out to a stream file in the IFS, then use the CPYFRMIMPF with parameters set with these delimiters, and it'll arrive in a PF.

Or if you know the length is never longer than some value, write it to a single-column PF (not DDS-based, use record length on CRTPF) first, then use CPYTOSTMF to get it to a stream file, than do the CPYFRMIMPF.

This takes heavy lifting out of it. I didn't say it was pretty!!! But you'd get it written quickly. Figuring out a CSV parsing routine - well, there are probably examples in C or whatever out there. Google for csv and parser

HTH
Vern

Alan Shore wrote:

Afternoon everyone
I am to receive a string that contains a number (9) of fields that are
comma separated.
Each of these fields COULD also contain commas, therefore these fields will
be incased in double quotes (")
Is there anything in SQL and/or RPGILE that will parse this data into
individual fields or is it a case of building my own logic

I've just re-read this e-mail and it looks familiar
I'll check the archives as well


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