RE: Parsing out a string

Thanks for your reply Dan, but I need to be able to process hundreds if not
thousands of records at a time
Is this possible using the process that you presented?
My first impression is that human intervention is required


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



"Dan Kimmel"
<dkimmel@rjssoftw
are.com> To
Sent by: "Midrange Systems Technical
midrange-l-bounce Discussion"
s@xxxxxxxxxxxx <midrange-l@xxxxxxxxxxxx>
cc

02/16/2010 04:35 Subject
PM RE: Parsing out a string


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






Select print from Excel. Choose your AFP driver printer. Click
properties. Click Image Options and click the Properties button that
pops up. Under Graphic Options select Enhanced. Click Photographic
dither.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
Sent: Tuesday, February 16, 2010 3:13 PM
To: Midrange Systems Technical Discussion
Subject: Parsing out a string


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
--
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.



--
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.