Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Identify if field contains Bad Words

Hi,

I have a table (Bad_Words) which contains a list of 100 odd Bad Words; such as

NO MAIL
NONAME
NOT GIVEN
NOT PROVIDED
NOT SUPPLIED
RETURNED

etc

etc

Now, I know how to identify if the full field matches one of these words.

What I am trying to work out is an easy way to identify if a field contains any of the words in this table

Ie. 'MAIL RETURNED' in a field would be caught as 'RETURNED' is in the Bad_Words table

Any thoughts?

Thanks

Stuart

0 Replies