A "replace field contents" with calculated result = "" will do the job.
Thanks for pointing me in the right direction, raybaudi. It took this newcomer a while to realize you were taking about a basic menu command: "Records/Replace Field Contents" and not a custom calculation or script. Once I found it, it was pretty simple. I just had to remember to have the proper field selected before going to the menu command.
That has to be one of the most important dialogues to read very carefully, as it is so easy to get it wrong. When you use that tool, please v-e-r-y deliberately read what it is asking you to check:
- is this field really the one you want to replace the data in?
- do you really mean to replace it in all 1655 records?
- is this data really what you want to replace into ALL the records?
Once you click 'Replace' there is no Cmd-Z - it cannot be undone.
Yes, thanks for the cautionary reminder, Sorbsbuster. (And, in this case, yes, that's exactly what I wanted to do.) As a newcomer to this Filemaker development thing, I frequently save copies as backup before any major changes. Such a quick, simple way to avoid many headaches later...
And if you are new to Replace Field Contents or are trying out something complex in terms of the calculation option, it's a good idea to make a back up copy of your file before you use this tool so you can go back and try again if it doesn't produce the results you expected.