Matching text to concatenated text

[#1]

I have a variable Doctor1 that contains the following text : DR. X,DR. Y. I am trying to compare the variable to a table field using the below but it isn't working:

=if(mixmatch(ATTENDING_NAME , (Doctor1)),2)

Can anybody assist please?

[phaneendra_kunc]

it doesn't work...with your current expression.

as you can see you don't have single quotes per name.

Usually it has to be like ------------> 'DR.X','DR.Y'

Replace your Doctor1 Variable with this...Not sure how you are calculating those names..

=chr(39)&Concat(NAME,chr(39)&','&chr(39))&chr(39)

And use $(Doctor1) in your mixmatch expression with out single quotes..

Regards

Phani

[#3]

Thanks a lot.

The above worked fine