Filter by list of words RRS feed

  • Question

  • I have a list of historical data that I update every week. When I filter and words are returned that are bad, I take action based off of that. I now have a list of words that is updated constantly. How can I use these list of words to filter my data set constantly? That is, never include these words (this list keeps getting larger and larger). Thanks!!
    Sunday, April 23, 2017 9:15 AM


  • Please elaborate;

    1. Are these words in 1 column or a few columns, or should 1 or a few tables be searched entirely?
    2. What should be done if the words are found: delete the table rows, add a column indicating bad words found, replace bad words with good words?

    Sunday, April 23, 2017 9:21 AM