How to remove a specific string without affecting parts of other strings?
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?
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.
