Just wondering if someone can provide some insight to the replace function...
Replace function I understand is
Replace (<field that needs replacement>, <string to be replaced>, <what new value is>).
It appears that <what new value is> must be a string. Can it be a string field?
replace([f1], "abc", [f2]) doesn't seem to work. I seem to be missing something. Any ideas?