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 U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
VL.JS.LIST.VAR1 = ':CONVERT (@VM,' ',VL.JS.LIST.VAR1):' Will the following work to get rid of all the @VM's (Not just the first) VL.JS.LIST.VAR1 = ':CONVERT(@VM,REUSE( ),VL.JS.LIST.VAR1):' George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org 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 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
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
Re: [U2] Selecting a List
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org 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 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
Re: [U2] Selecting a List
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
Re: [U2] Selecting a List
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: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org 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 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Selecting a List
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
Re: [U2] Selecting a List
CHANGE works in UV too. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, June 08, 2011 12:07 PM To: U2 Users List Subject: Re: [U2] Selecting a List 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
Re: [U2] Selecting a List
What system ? this works fine in UV. 001 x=@VM:@VM:@VM 002 crt x 003 crt convert(@VM,x,x) 004 end RUN DEV.BP X ²²² xxx -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org 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 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
Re: [U2] Selecting a List
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 jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/08/2011 12:11 PM Subject:Re: [U2] Selecting a List Sent by:u2-users-boun...@listserver.u2ug.org 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: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, June 08, 2011 11:47 AM To: u2-users@listserver.u2ug.org 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 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 -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ 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