Remove items from a list based on items in another list

[Squeaky Data]

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

[Raybaudi]

Hi

there are many custom functions, you can try this:

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

[comment]

See also:

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