Reverse Filter?

[mikeytt]

I have a field (KEEP) which contains characters.

KEEP = "a b c x y z"

I have a second field (REMOVE) which contains characters that I want to remove from the first field.

REMOVE = "a y z"

So the result i would be looking for would be:

RESULT = "b c x"

How can I do this via a calculation? I need a sort of reverse filter function?

Thanks

[Genx]

this cf should do it: http://www.briandunning.com/cf/193

[Stuart Taylor]

This will do it

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

[mikeytt]

Perfect. Works wonderfully. Thank you.

[Stuart Taylor]

Genx beat me to the draw + his CF is much slicker for your needs