Basic Question regarding Filtering a list of texts

Hey All,
I’m sure I’m going to do a face slap here but I’m having trouble filtering a list of texts.

Basically I have 2 lists of texts one has 100 items, the other has up to 100 items (lets say 20 for this example).
Those 20 items will be the same as some of the items in the 100 items.

I basically want to filter out the 20 items from the 100 so I have the remaining list of 80 items

example

List 1
apple
orange
blue
red
warm
hot
cold
day
night

List 2
Blue
hot
day

End Result List
apple
orange
red
warm
cold
night

I’ve tried to filter the list but I don’t have the “is in” option available.
For some reason I just can’t figure it out

Hey @chad

Is this list being pulled from a custom state or database.

Quick thought, have you tried the :unique elements modifer?
image

Thanks for the reply Luke
Yes 2 custom states,
Unique Elements will just give me a list of all the items I believe. It wont give me back the a list of items that aren’t doubles, it just stops doubles from being in the list if that makes sense.

You might want to look at an Advanced filter.

That will allow you do “List 2” does not contain this item from list 1.

Not sure if its just me Nigel but I dont think I can do Advanced Filter on a list of text’

Ah, no you are right. But you can still do it …

1 Like

So I’ve just tried to replicate what you’ve done but I dont think it works, generally the “is in”, “isn’t in” are the operators that do the trick but “doesn’t contain” returned an empty list

sorry my bad it does work

This topic was automatically closed after 70 days. New replies are no longer allowed.