Jeff, Thanks for the info on EREPLACE! It looks like this would allow me to replace a specified number of the substrings - something I've been wrestling with on another assignment...
Thanks again, Greg From: Jeff Schasny <[email protected]> To: U2 Users List <[email protected]> Date: 06/08/2011 12:11 PM Subject: Re: [U2] Selecting a List Sent by: [email protected] EREPLACE function? SYNTAX EREPLACE (expression, substring, replacement [,occurrence [,begin]] ) DESCRIPTION Use the EREPLACE function to replace substring in expression with another substring. If you do not specify occurrence, each occurrence of substring is replaced. occurrence specifies the number of occurrences of substring to replace. To replace all occurrences, specify occurrence as a number less than 1. Glorfield, Gordon wrote: > What about SWAP? > > SWAP str.expr1 WITH str.expr2 IN var > > The UniBasic SWAP command replaces all occurrences of one substring with a second substring. The search string does not have to be the same length as the replacement string. SWAP supports mulitbyte languages. > > -----Original Message----- > From: [email protected] [ mailto:[email protected]] On Behalf Of Greg Coelho > Sent: Wednesday, June 08, 2011 11:47 AM > To: [email protected] > Subject: Re: [U2] Selecting a List > > Hi All, > > Again, I need a little help. > > The following PROCEDURE LINE works just fine. In this case I'm just > inserting the variable V.CALENDAR.YEAR to complete my file suite and I am > going after 2 alphanumeric records ('P2021422' 'P2083158'). > > PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = > 'P2021422' 'P2083158'" > > The problem arises when I attempt to select from a LIST (below) > > PROCEDURE LINE "SELECT GLA.":V.CALENDAR.YEAR:" WITH GLA.REF.NO = ": > VL.JS.LIST.VAR1 > > Of course the system does not like the Value Marker so I need to get rid > of it... > > VL.JS.LIST.VAR1 = "'":CONVERT (@VM,"' '",VL.JS.LIST.VAR1):"'" > > The hope here is to replace @VM with ' ' and then place the ' at each > end... but CONVERT will only switch one for one - one @VM for a single > single quote (') which results in a quote mismatch. > > Any suggestions? > > Greg > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ------------------------------------------------------------------------ _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
