The opposite of 'filter'

[egor]

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.

[Tom Assia]

Hello,

There is this way :

 

Tom

remove.fmp12

[egor]

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.

[Tom Assia]

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

[egor]

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

 

[Tom Assia]

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)

[Lee Smith]

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.

[egor]

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

[Fitch]

Another approach is to use a custom function such as:

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