topic Re: Search for Characters in string - WildMatch() / Match() or other in QlikView

Search for Characters in string - WildMatch() / Match() or other

chris1987 — Wed, 27 Jan 2016 17:01:50 GMT

Hi,

I have a field that contains codes (relevant to the company I work for). I want to search this field to determine if it contains any character in a specified array.

What I would usually do in excel is:

$AS2 = "GCBZ"

IF(COUNT(SEARCH({"A","R","C"},$AS2,1))>0,"Found it, do this!","Not Found - Try again!")

This would return "Found it, do this!" as the cell contains "C"

I can repeat the above in QV but only by doing the following:

[ProgStage]) = "GCBZ"

IF(WILDMATCH(UPPER([ProgStage]),'A*','*A*','*A'.'R*','*R*','*R','C*','*C*','*C')>0,"Found it, do this!","Not Found - Try again!")

Is there any way I can do the above formula without repeat three instances of each character - sometime I have to search for 15 different characters - 45 options.

The letters will not always appear in the same order and may or not be at the beginning / end of the string. I've also tried using index() but obviously this is for one search string.

Any help would be appreciated.

Thanks in advance

Chris

Re: Search for Characters in string - WildMatch() / Match() or other

Gysbert_Wassenaar — Wed, 27 Jan 2016 17:13:30 GMT

If(Len(ProgStage)>len(PurgeChar(UPPER(ProgStage),'ARC')),'Found it, do this','Not Found - Try again!')

Re: Search for Characters in string - WildMatch() / Match() or other

swuehl — Wed, 27 Jan 2016 17:21:22 GMT

What about FindOneOf() string function?

Re: Search for Characters in string - WildMatch() / Match() or other

rwunderlich — Wed, 27 Jan 2016 17:32:55 GMT

If( FindoneOf(ProgStage,'ARC') ,'Found it, do this','Not Found - Try again!')

-Rob

http://masterssummit.com

http://qlikviewcookbook.com