I don't get the problem.
Why would you want to do this in the first place?
Why not just convert the commas to @VM, use LOCATE and convert the @VM
back to commas?
BTW if the first string is HELL or it is the first entry then counting
,HELL, won't find it either.
KISS!
Mecki
On 31/10/2011 20:41, George Gallen wrote:
Be careful using a straight count,
Because "HELL" will be found in in the word "HELLO" for instance, and would not
be added
Make sure you surround your search criteria with the delimiters being used, as
noted in one of the replies.
So, ,HELL, would not be found if ,HELLO, were in the list.
George
-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Monday, October 31, 2011 4:15 PM
To: U2 Users List
Subject: Re: [U2] Using 'MATCH'
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"<bob_woodw...@k2sports.com>
To: "U2 Users List"<u2-users@listserver.u2ug.org>
Date: 10/31/2011 01:55 PM
Subject: Re: [U2] Using 'MATCH'
Sent by: u2-users-boun...@listserver.u2ug.org
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.
_______________________________________________
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
