NOT match function.

[#1]

Hi community,  Is there anyway to make a not match function.  I know that there is a match function.  I am wondering if there is a complement to it or how one would go about doing it with an if statement?

[d_pranskus]

Hi

What are you want to achieve?

This is MATCH function. It will return 0 if it doesn't find str in expr..exprN.

match( str, expr1 [ , expr2,...exprN ] )

The match function performs a case sensitive comparison.

Example:

match( M, 'Jan','Feb','Mar')

returns 2 if M = Feb

returns 0 if M = Apr or jan

Hope it helps

Cheers

Darius

[#3]

I want it to return 0 if there is a match.

[d_pranskus · Accepted solution]

Hi

The shortest way I came up with is to use following expression

1-SIGN(MATCH(str, expr1 [ , expr2,...exprN ]))

Cheers

Darius

[CELAMBARASAN]

Hi,

     You can get it as many ways

     simply Not Match() gives you 0 if there is a match otherwise -1.

     1+(Match()>0) gives you 0 if there is a match otherwise -1.

     1-Sign(Match()) gives you 0 if there is a match otherwise -1.

Celambarasan