topic Find words in fields in QlikView https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303865#M616551 <HTML><HEAD></HEAD><BODY><P>I want to find words like is, and, for, in a dimension and delete these words to create a cleaner dimension. Any suggestions? </P></BODY></HTML> Fri, 02 Jun 2017 13:20:29 GMT 2017-06-02T13:20:29Z Find words in fields https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303865#M616551 <HTML><HEAD></HEAD><BODY><P>I want to find words like is, and, for, in a dimension and delete these words to create a cleaner dimension. Any suggestions? </P></BODY></HTML> Fri, 02 Jun 2017 13:20:29 GMT https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303865#M616551 2017-06-02T13:20:29Z Re: Find words in fields https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303866#M616552 <HTML><HEAD></HEAD><BODY><P>Can you provide few values or string?</P></BODY></HTML> Fri, 02 Jun 2017 15:07:27 GMT https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303866#M616552 Anil_Babu_Samineni 2017-06-02T15:07:27Z Re: Find words in fields https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303867#M616553 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/165705_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Sat, 03 Jun 2017 00:14:05 GMT https://community.qlik.com/t5/QlikView/Find-words-in-fields/m-p/1303867#M616553 johnw 2017-06-03T00:14:05Z