Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Find words in fields

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

2 Replies

Re: Find words in fields

Can you provide few values or string?

MVP
MVP

Re: Find words in fields

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.

Capture.PNG

Community Browser