if() match () with several expressions in script?

[#1]

Hi guys,

is it possible to select several expressions like that ?

search is select all the X:

X >=400000

X <=599999

X = 677000

X = 688000

X IS NOT = 494500 494700 494800

if tried with

If(WildMatch("X",'4?????','59????','677000','688000'),'TEST') as TEST

But I don't know, how to NOT SELECT expresions ?

Kind regards.

[alexandros17]

I think it is not possible with only one wildmatch ... you must use at least two, one to include and one to exclude.

Pay attention to the sysntax, first use the whole string , then the other to compare so:

If(WildMatch(TEST, "X",'4?????','59????','677000','688000')) as TEST

[tresesco]

Try like:

If(WildMatch("X",'4?????','59????','677000','688000') and Not Match("X",'494500' ,'494700', '494800')  ,'TEST') as TEST

[Gysbert_Wassenaar · Accepted solution]

if( ((X >= 400000 AND X <= 599999) OR match(X, '677000', '688000')) AND NOT match(X, '494500', '494700', '494800'), 'TEST') as TEST