Contains with list of strings

[stergios99]

Hello, i want to create a custom fitler on a look, and exclude rows that contain a list of strings in their name.

for example i want to exclude any rows that have “yas”,"lwl","part" in their name.

in sql i would do select …. where name not in (“yas”,"lwl","part") 

in looker ive found contains, but works only with one string not with multiple.

I also have 2 more requirments:

1. i dont want to use or operator cause there are 100 values so i would need to do it 100 times

2. i want to use the lowercase of the name, for example if name is "Yas a lot”, then it needs to be excluded as it contains "yas”