That's the question of the day: I'd like to use a local or global variable for the text part of the Substitute command:
Substitute ( text ; searchString ; replaceString )
I tried using a global variable that's defined as a fieldname but no matter what I put in the search and replace strings, the output is always the same: the fieldname. Am I missing something or does one need to select a "hard" fieldname from the field list in the Replace dialog?
TIA for your help!