conditional function-help

Fri, 27 Jun 2014 11:09:30 GMT

hieeee guys,

Please tell me how to use match ,wildmatch and mixmatch with some example and where they are used in script or on object side..

please explain

Re: conditional function-help

Gysbert_Wassenaar — Fri, 27 Jun 2014 11:15:21 GMT

Look at the help file. The information you're looking for is available in the help file. Honestly, I kid you not.

its_anandrjs — Fri, 27 Jun 2014 11:20:43 GMT

All from help

1. Match Function

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

2. WildMatch Function

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

The wildmatch function performs a case insensitive comparison and permits the use of wildcard characters ( * and ?) in the comparison strings.

Example:

wildmatch( M, 'ja*','fe?','mar')

returns 1 if M = January

returns 2 if M = fex

3. MixMatch Function

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

The mixmatch function performs a case insensitive comparison.

Example:

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

returns 1 if M = jan

This will more clear to you.