How to remove certain words from a column of text data?

[rahulchauhan]

Hi,

I have text data (customer responses) from which I need to remove any stop word contained in my list (I have a list of about 500 stop words).

For e.g. -

Text: He loves to eat out every Sunday

Stop Words: He, to, out, every

Required Result: loves eat Sunday

Essentially I have one customer response in every row of data and I need the every word from the entire list of Stop Words should be removed from every single row of data.

Stop WordsCustomer Response

[Claje · Accepted solution]

Hi,

Take a look at the Find Replace tool.  You can tell it to match only on whole words, and can even set it to be case insensitive if you want to filter out both "he" and "He".  For your case I would recommend using the "Match Whole Word Only" option, as well as "Replace Multiple Found Items".  The only thing you will need is a second text column in your Stop_Words input that has nothing in it, so that the Find Replace tool can be instructed to replace what it finds with nothing.

[ddiesel]

+1 to @Claje's suggestion.

Find and Replace will definitely work. Check out this question I answered for a user with a similar user case.

Find exact matches from multiple fields using batch macro

I hope it helps!

[rahulchauhan]

Find and Replace worked for me. Thanks!