Re: Parsing out a string

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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
>