Re: Parsing out a string

Thanks for your reply Martin
Man - I love this list
This is another one that I will forward home to read tonight



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



Martin Rowe
<dbg400.net@gmail
.com> To
Sent by: Midrange Systems Technical
midrange-l-bounce Discussion
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

02/16/2010 04:55 Subject
PM Re: Parsing out a string


Please respond to
Midrange Systems
Technical
Discussion
<midrange-l@midra
nge.com>






On 16 February 2010 21:12, Alan Shore <AlanShore@xxxxxxxx> 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

Hi Alan

I've used a simple RPGLE parser for this, which copes with a variable
string delimiter (such as "") as well as a variable field delimiter.
I've put the code up at
http://www.dbg400.net/foswiki/bin/view/DBG400/RpgleSPLITCSV

Regards, Martin
--
martin@xxxxxxxxxx http://www.dbg400.net
AS/400 | iSeries | System i Open Source/Free Software
Debian GNU/Linux - http://www.debian.org
Foswiki - The Free Open Source Wiki, http://foswiki.org/
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.