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

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

Regex

Transformation

Accepted answers

Claje

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.

All comments

Claje

Hi,

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!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703