I was testing only single digits for is among comma seperated BUT that was not my problem because 'is in' would not have worked either due to my method of deleting line of the original list instead of building a separate list from the result.
Thanks though and I see I could have use the is in operator now.
Tom
On Nov 21, 2003, at 10:18 PM, J. Landman Gay wrote:
On 11/21/03 7:49 PM, Thomas J McGrath III wrote:
My real problem was that "is among" was not finding sets of groups that were similar but transposed. In my need to find a solution I added the part about converting a line like 123 into 1,2,3 so that "is among" could work.
I really want to understand why it didn't work though. Any clues???
The "is among" operator tests for exact matches, so it won't work with transposed numbers. For example, "1" is among the items of "1,2,3" but is not among the items of "12,13,14". The "is among" operator is an automatic way of setting wholeMatches to true.
On the other hand, since you are testing only single digits, you could have used the plain "is in" operator. 1 is in "123" and likewise 2 and 3 are both in "123". However, "213" is not in "123", so you'd have to test each digit individually.
-- Jacqueline Landman Gay | [EMAIL PROTECTED] HyperActive Software | http://www.hyperactivesw.com
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
Macintosh PowerBook G-4 OSX 10.3.1, OS 9.2.2, 1.25 GHz, 512MB RAM, Rev 2.1.2
Advanced Media Group Thomas J McGrath III 2003 [EMAIL PROTECTED] 220 Drake Road, Bethel Park, PA 15102
_______________________________________________ use-revolution mailing list [EMAIL PROTECTED] http://lists.runrev.com/mailman/listinfo/use-revolution
