topic Re: How to remove a specific string without affecting parts of other strings? in App Development

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

QlikToFindOut — Wed, 27 Mar 2024 12:59:19 GMT

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?

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

QlikToFindOut — Wed, 27 Mar 2024 14:12:08 GMT

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.

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

BrunPierre — Wed, 27 Mar 2024 14:34:01 GMT

What should be the output then?

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

QlikToFindOut — Wed, 27 Mar 2024 15:24:54 GMT

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.