Guys, Thanks for the great suggestions. I believe that I did get MATCH confused with COUNT thinking that it could navigate a delimiter... In this situation I'm thinking that just using COUNT would be the best solution. I do appreciate the diversity of the solutions presented.
Thanks! Greg From: "Woodward, Bob" <[email protected]> To: "U2 Users List" <[email protected]> Date: 10/31/2011 01:55 PM Subject: Re: [U2] Using 'MATCH' Sent by: [email protected] You might also be able to use COUNT. IF COUNT(X.STRING,X.CODE) = 0 THEN X.STRING := X.CODE Not knowing what your potential codes are, though, they may or may not fit your needs. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Martin Braid Sent: Monday, October 31, 2011 10:44 AM To: U2 Users List Subject: Re: [U2] Using 'MATCH' Hi Greg, I would convert your string to a VM array, use the LOCATE syntax to add it if relevant and then convert back to a string. Martin (I am not going to worry why you aren't just using an array) -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Greg Coelho Sent: 31 October 2011 17:38 To: [email protected] Subject: Re: [U2] Using 'MATCH' Hey Guys, I am concatenating an alpha code into a string providing that the code does not already exist (in the string). If my existing string = X.STRING and my code = X.CODE should the following work? IF X.STRING MATCH X.CODE THEN END ELSE X.STRING = X.STRING:',':X.CODE END Thanks! Greg _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: 6th Floor, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. This message has been scanned for malware by Websense. www.websense.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 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
