Ken, Tom, Francis
thanks for your replies
I was on the right track, realizing that I would also have to use %scan as
well
Tom - I never thought of using SQL, that's a good idea
Alan Shore
NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill
Ken Sims
<mdrg7319@kensims
.net> To
Sent by: rpg400-l@xxxxxxxxxxxx
rpg400-l-bounces@ cc
midrange.com
Subject
Re: %replace question
01/18/2008 05:02
PM
Please respond to
RPG programming
on the AS400 /
iSeries
<rpg400-l@midrang
e.com>
Hi Alan -
On Fri, 18 Jan 2008 16:24:20 -0500, Alan Shore <AlanShore@xxxxxxxx>
wrote:
My head is stuck on using %replace - is this correct, or should I be using
something else?
You're on the right track. You would want to use %scan to find "" and
%replace to replace "" with ". Continue looping until not found.
BUT ... you need to be careful if there could be more than two double
quotes together. If that circumstance can occur, you'll need to write
the code carefully to make sure that the result is what you want.
For example, if you always start the scan at the beginning of the
field, or any point in the string at the replacement point or earlier,
any number of consecutive "s will always be collapsed to just one ".
Ken
Opinions expressed are my own and do not necessarily represent the views
of my employer or anyone in their right mind.
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
