Go to Field [where you want to replace]
I prefer "Replace Field Contents" instead of "Find/Replace".
Thank you for the response...
...I am curious about the Go to Field [ ] - I set the Find/Replace in my script to "Search Within All Fields" - shouldn't that force it to go to all fields? It does when run manually.
I have 25 fields, so just a pain to do a Go to Field then Find/Replace...
I appreciated the suggestion on "Replace Field Contents" but I am an looking to replaced a specific word in the field not the entire field ...so not sure Replace Field Contents would work - but willing to give it a try.
Hmm, I assumed you replace one field, since database usually have different information in each field.
You can find/replace "All Fields" but script step don't show how you specified the option, this is bad of script workspace, not us.
"Replace All" means "all occurrences", not "all fields" nor "all records", did you confirm it in "options" in dialog?
Sctipt option "With dialog:on" shows only "OK/cancel" dialog, that can't set option at the time.
I agree, if you need doing same replacement on 25 fields, it is a bit work for "RFC". It can be done with
Substitute ( aField ; "#CE#" ; $CELongName )
but you need 25 script steps or looping 25 times.
Your variable name is first written as $EntityName, is this correct?