Search for a text string but not another text string

[#1]

In the search dialog box, how would you search for a text string like 'mac' but not for text string like 'machine' or don't show the results with 'machine'?

[MayilVahanan]

Hi

Please refer this

http://community.qlik.com/blogs/qlikviewdesignblog/2013/10/16/text-searches

[#3]

Thanks Mayil for your quick response.  Very useful link and info.  However, I still don't see how to do the search that I want.  Again, I want to search for 'mac' in the text, but I do not want to see results that have 'machine' or 'macon' or 'macdonald'.  Basically, I would like to search for records matching Text1 but don't show any records matching Text2, Text3, or Text4.

[jonathandienst]

Hi

     =WildMatch(field, '*mac*') = 1 And WildMatch(field, '*machine*', '*macon*', '*macdonald*') = 0

HTH

Jonathan

[MayilVahanan]

Hi

Try like this

*Mac

= WildMatch(Test,'*Mac') in Textbox

[hic · Accepted solution]

If you want 'mac' but not 'mach', then you can use

(*mac* ^ *mach*)

HIC

[#7]

I tried this method too, but I kept running into runtime error.  The syntax makes sense.  I'll try again later.  In the meantime, I used the other suggestion since it is working.  Thanks.