I have a list of items from which I want to remove specific items based on another list of items.

So if List A is:

Mouse

Cat

Dog

Fish

Bird

And the items to remove in List B:

Cat

Fish

Producing a new List A:

Mouse

Dog

Bird

I can do this with a looping script and a substitute function that would remove one item at a time from List A but thought I would see how others would aproach this as both lists could be very large and looping might be slow.

Thanks,

Steve

Hi

there are many custom functions, you can try this:

http://www.briandunning.com/cf/193

See also:

http://www.fmforums.com/forum/showtopic.php?tid/187248/#253049