Jump to content
Sign in to follow this  
mikeytt

Reverse Filter?

Recommended Posts

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.