Find words in fields - Qlik Community

Report Inappropriate Content · ‎2017-06-02

I want to find words like is, and, for, in a dimension and delete these words to create a cleaner dimension. Any suggestions?

Anil_Babu_Samineni · ‎2017-06-02

Can you provide few values or string?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

johnw · ‎2017-06-02

I find myself wanting to use mapsubstring() to convert common words to blanks, but it's not iterative. So instead I used subfield() to break the text into words, skipped the words we don't care about when loading that table, then concatenated them back together again. Seems to work, but would be more complicated with punctuation and capitalization.