Use of 'Not Match' function with a variable

[Anonymous]

I have the following 'Not Match' function:

If( Not Match(_View, 'Patent Analytics' , 'FDA Analytics') , _View)

Can the string 'Patent Analytics', 'FDA Analytics' be replaced with a variable and use the variable in the function?  If so, how can this be accomplished.

Regards.

[tamilarasu · Accepted solution]

Hi Christopher,

Try,

Variable Name: vList

Definition:    'Patent Analytics' , 'FDA Analytics'

= If(Not Match(_View,$(vList) ), _View)

[ahmar811]

hi Christopher Chitemerere‌

try this

create the variable like below

set vMatch='Patent Analytics' , 'FDA Analytics';

and write the condition like that using variable

If( Not Match(_View, $(vMatch)) , _View)

hope this help

Regards

Ahmar

[tresB]

Define variable (say, vExclude) like : 'Patent Analytics','FDA Analytics'

Note, No '=' sign; ignore error red marks. Then :

If( Not Match(_View, $(vExclude)) , _View)

[Anonymous]

THANK YOU

[Anonymous]

Thank you Ahmar

[Anonymous]

Tresses thank you