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?

[alexandros17]

Use this syntax:

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

Let me know

[#3]

No result

[maxgro]

the variable should be

'DR. X','DR. Y.'

[#5]

The variable can hold different doctor names depending on the user selection.

[tresesco]

I guess you need:

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

[jagan]

Hi,

Try like this, you need to give single quotes for variable, since it is a string.

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

Regards,

Jagan.

[#8]

I entered the following expression but still getting no values:

if(mixmatch('$(Doctor1)' ,ATTENDING_NAME ),2)

[jagan]

Hi Nassar,

Try like this

=if(Index(Upper(ATTENDING_NAME ) , Upper(Doctor1)),2)

Regards,

Jagan.

[tresesco · Accepted solution]

Mixmatch() is exact match(case insensitive) function. For your case, you have to use wildmatch() or substringcount() or index(). Try like:

if(Index('$(Doctor1)' ,ATTENDING_NAME ),2)

Note: to take care of case insensitivity, use for both strings upper()/lower().