I cannot figure out why the If-Then statement fails to detect variable Local_Clinic?
Does it not work properly upon executing or are you just wondering why you’re not seeing the results in the editor?
When you’re editing the macro, you will never see the results of a local variable because they are written while the macro is running, and then immediately deleted after. So unless the macro is running right at this moment, that variable doesn’t even exist.
I'd say most likely that the source string that contains "Advanced Healthcare" also contains some invisible, non-printing characters.
This works for me:
Thank you. Everything is working now.