Search functions where field contains Asterisk

[Anonymous]

Hi All,

My field in question has been marked with an asterisk to indicate that it is not in use anymore.  This becomes problematic when using Search functions in qlikview.  Is there a way around this issue?

Field Example:

*Product1 102020

Product2 10102 Bulk

Product 3 10101

What I need is to identify all fields that do not contain the word "Bulk" and do not contain an Asterisk.

I was trying to use the below formula but the asterisk provides an issue.  Can anyone make any recommendations?

if(Product like '*Bulk','',Product) as a calculated dimension.

Regards,

[Anonymous]

My Solution is as below, if anyone has anything better please let me know.

=if(ProductDetail like '*Bulk' or Replace(ProductDetail,'*','%') like '*%*',ProductDetail,'')

[Anil_Babu_Samineni]

How you want to search? May be Replace it with * to any other functions like !@#$%^&() and then use that condition where you are?

[devarasu07]

Hi,

another way you create like this

pick(WILDMATCH(Replace(ProductDetail,'*','%'),'*%*'),ProductDetail,'')

[ashwinishinde]

try this,

if(left(Product,1)='*',Product,

if(WildMatch(Product,'*Bulk'),Product)) as dim,

[Anonymous]

The * is not necessarily the first character in the field