Hi, I am trying to build a blacklist feature for a list of URLs:
- I have a list of URLs in a CSV
- I also have a list of “killwords” in a blacklist. (i.e. like “forum”, “comment” etc.) in a Google Sheet
Now I want to delete all rows in the URL list that contain any of the words from the blacklist (a few hundred words).
The expected result is that I receive a list of URLs where all URLs have been deleted where a killword existed.
Can anyone give me a hint how to build this?