Re: Parsing out a string

[Alan Shore <AlanShore@xxxxxxxx>]

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.