Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi
The shortest way I came up with is to use following expression
1-SIGN(MATCH(str, expr1 [ , expr2,...exprN ]))
Cheers
Darius
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
I want it to return 0 if there is a match.
Hi
The shortest way I came up with is to use following expression
1-SIGN(MATCH(str, expr1 [ , expr2,...exprN ]))
Cheers
Darius
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