topic Re: mutiple wilmatch and simple if in Water Cooler

mutiple wilmatch and simple if

jmialoundama — Fri, 07 Feb 2020 22:41:04 GMT

Hi,

I have a a colonne with differents code to exclude the next code:

I test this code, but i have errors :

if(WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,NULL())
if (CODE > 401231,CODE)
)

Thanks in advance

Sue_Macaluso — Fri, 22 Nov 2019 16:26:01 GMT

@jmialoundama Are you using QikView or Sense? I would like to move this into the correct product forum.

sunny_talwar — Fri, 22 Nov 2019 16:28:09 GMT

What is the error message?

prasadmundewadi — Mon, 06 Jan 2020 17:07:53 GMT

You IF syntax is incorrect:

if(WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,NULL())
if (CODE > 401231,CODE)
)

Here is the right syntax (you might want to rearrange the NULL() but basically it is syntax error):

if (WildMatch(CODE,'*5','*5A'),CODE,
if(Not WildMatch(CODE,'*603*'),CODE,
if (CODE> 401231,CODE,NULL())))

rwunderlich — Tue, 21 Jan 2020 01:22:17 GMT

Instead of a nested if, how about using OR:

If(WildMatch(CODE,'*5','*5A')
or (Not WildMatch(CODE,'*603*')
or CODE > 401231
,CODE)

-Rob