Guys, As always a number of great options! I was able to throw in SWAP with the least effort and it's working great!
Thanks again, Greg From: "Bob Woodward" <bob_woodw...@k2sports.com> To: "U2 Users List" <u2-users@listserver.u2ug.org> Date: 06/08/2011 12:06 PM Subject: Re: [U2] Selecting a List Sent by: u2-users-boun...@listserver.u2ug.org I'm assuming this is in a basic program and you want to use CHANGE instead of CONVERT. In Unidata, anyway. -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Wednesday, June 08, 2011 9:00 AM To: U2 Users List Subject: Re: [U2] Selecting a List On 08/06/11 16:47, Greg Coelho wrote: > 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? > Yes. I think you need the ?REPLACE? function. There is a function that replaces one string with another. It might be EREPLACE instead. Anyways. Read the BASIC manual - it is there. Cheers, Wol _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
