Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
QlikToFindOut
Creator
Creator

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?

Labels (2)
3 Replies
QlikToFindOut
Creator
Creator
Author

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
Partner - Master
Partner - Master

What should be the output then?

QlikToFindOut
Creator
Creator
Author

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.