Is there a way to do the opposite of the filter function?  For example:

 

Field 1 contains the text “dog cat giraffe crocodile”

Field 2 contains the text “dog giraffe”

 

I would like field 3 to be a calculated value which displays “cat crocodile” ie it removes from field 1 whatever words are typed into field 2.

Hello,

There is this way :

 

Tom

remove.fmp12

Blimey that was quick! Exactly what was needed. Now I'll just take a couple of days to work out how you did it!  Thanks.

Set solved if you have the answer and a like

 

Some explanation :

we get the field b (dog giraffe) and transform it by substitute space with carrier return, so you've got a value list.

You count the number of fields in b (in this case 2) and make the substitute in field a with the current element of the value list.

So : 1st -> substitute dog by "" in the main field

2nd -> substiture giraffe by "" in the main field

only 2 values so exit and set field c

 

Tom

Now I'm going to seem really thick ... but where do I mark the topic solved ... and where can I like it?

 

hum, it seems that you can't

but when you set like it with the small heart people see the good answer (sorry for my poor english)

Hi egor and Tom,

A reply by the OP -  of thank you, that work, or that's what I needed, (or something similar).

The trophy works when you post it to the person who provided you the answer.  

It also acts as an at-a- boy, which we all like to hear.

OK. Thank you to Tom. A neat and sophisticated solution to my question!  😀

Another approach is to use a custom function such as:

https://www.briandunning.com/cf/926