How to remove a specific string without affecting parts of other strings?

[QlikToFindOut]

Hi,

Having some issues with my Qlik script in which I am trying to remove specific strings in my table. For context, I am utilizing a word cloud and need to remove specific stop words. For example, here's my table:

ID	Text
1	the
2	thesis

When I plug in either a replace or using a mapping table to remove "the", I wind up with the following:

ID	Text
1
2	sis

I wind up with a blank space and "thesis" loses the "the" in it. How do I get around this?

[QlikToFindOut]

I solved the issue of blank spaces by using a LEN(string) > 0, but still facing the issue of my replace or mapping load removing parts of other strings.

[BrunPierre]

What should be the output then?

[QlikToFindOut]

Ideally, it should be the following:

ID	Text
2	thesis

I figured it out, I just decided to use a WHERE clause with a not equal to.