topic Search for an exact match in QlikView

Search for an exact match

Wed, 16 Mar 2011 12:16:49 GMT

Hi,

I'm having the following problem.

I need to search for a combination of letters (i.e. AB) in a string.

The following situations can occur in the string to be search in. Only the ones marked with a !! should be returned as correct

ABC
C,AB,D,E !!
D,E,A
ABCDE, A

The logic should be:

search for a string, which is an exact match, knowing that the string to search in can be a single word, or a list of words separated by either a comma or a space (or a combination of both).

This is what we currently have... but this gives too many results

If((index(searchin, searchfor)=0), 'Yes', 'No')

Thanks!

Maarten

Search for an exact match

Wed, 16 Mar 2011 12:36:54 GMT

try like this

=if(substringcount('String','a')<>'0' and substringcount('string','b')<>'0', 'Yes','No')

regards

A'run'

Search for an exact match

Wed, 16 Mar 2011 12:50:29 GMT

Hi A'run'

So if I get it right, you would do this for every character...

Knowing that this needs to be used on every row of a table, it is impossible to predict the number of characters. Correct me if I'm wrong ofcourse 🙂

Thanks for your help!

Regards,

Maarten