Comparing two number lists as variables

[James Gill]

I have two variables I have assigned through a script. Each variables contains all the primary key values of a specific table. I want to step through the first list and see if it contains any values that are contained in the second list and, if so, apply a condition to it.

The obvious choice for this would be the PatternCount command but unfortunately this will not work for numbers.

How would I do this?

Edited November 23, 2010 by Guest

[Vaughan]

The obvious choice for this would be the PatternCount command but unfortunately this will not work for numbers.

Why will it not work?

As soon as you have a return-delimited list of numbers, it's not a number any more. It's a text string.

Check Brian Dunning's CF web site there are several that allow lists to be compared.

[comment]

The obvious choice for this would be the PatternCount

I think the obvious choice would be the FilterValues() function - but I am not sure what exactly you are trying to do.

[James Gill]

Whoops, I duno how I missed that but ya, that works perfectly. Thanks!