If you are trying to look for an arbitrary delimited string, I think the
safest thing to do is
IF INDEX(',':X.STRING:',', ',':X.CODE:',',1) THEN
X.STRING=X.STRING:',':X.CODE
On Mon, Oct 31, 2011 at 10:55 AM, Woodward, Bob
<bob_woodw...@k2sports.com>wrote:
> 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: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] 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: u2-users-boun...@listserver.u2ug.org
> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
> Sent: 31 October 2011 17:38
> To: u2-users@listserver.u2ug.org
> 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
> U2-Users@listserver.u2ug.org
> 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
> 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
>
--
George Smith, Phoenix, AZ
Member of the Independent Computer Consultants Association since 1983
Member of the Institute for Management Consulting since 2007
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
