Remove Rows with Stop Words

Supply the terms you want to filter and review the two output lists together.

Stop Word Row Filter

1. Paste the source rows into Insert list. Enter the terms to find in Stop words, one per line.
2. Leave Case-sensitive off to match letter-case variants. Select it when capitalization should change which rows are selected.
3. Click Execute to process the current input.
4. Read Rows without stop words and Rows with stop words. Rows remaining and Rows removed count the two groups; the source text stays available above them.
5. Click Copy under the output you want to keep. Use Clear where shown to clear the text fields; option selections stay as set.

For apple pie, pineapple, and pear, enter apple as the stop word. The kept result is pear; both other rows go to Rows with stop words.

Terms match inside a row

Matching uses literal substrings, not whole-word boundaries. A term such as apple also matches pineapple. Each row is selected when any supplied nonempty term appears in it.

Separate rows without changing their contents

The filter moves complete matching rows into the second output. It does not delete only the matching words or apply colored highlighting inside the source text.