many thanks to the people who added comments to this issue.
FYI, at the end, I did something pretty similar to the solution
presented here by Fred.
At the same time I wrote my first Filter Guide so I got to know how
goooooood the Remedy is !!!!!
What I do is:
1- if CC list != $NULL$
then tempfield-1 = CC List
2- tempfield-2 = first line of tempfield-1
3- check if mailing-list exist for this tempfield-2
4- if not, clean first line of tempfield-1 and tempfield-2
5- if next line exist in tempfield-1 go to 2 and loop
:-)
...
now I have something more difficult to do.
So I'll probably get back to you later on the to-be-followed ;-)
Cheers
Serouche
Grooms, Frederick W wrote:
The wildcard(s) in a LIKE statement are on the right side of the LIKE.
Since you have to deal with multiple values in the CC field, what you
will have to do is to loop thru the $CC list$ field and parse the values
into a temp Display Only field and compare the temp field with the
mailing list field. Something like ...
1. Set TempField1 = $CC list$
2. if TempField1 contains a Return (line feed)
grab the value up to the Carriage Return and put it in TempField2
remove TempField2 (including the Carriage Return) data from
TempField1
else
set TempField2 = TempField1
set TempField1 = $NULL$
3. compare $Field B$ to TempField2 ( $Field B$ LIKE (("%" +
$TempField2$) + "%") )
do what you need to if the data is in Temp B
4. if TempField1 != $NULL$ ( more values to check)
goto 2
Fred
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers
Are"
