how to do a find and replace of all blank entries
GOAL: to perform a find & replace of all blank values in a certain field to "NO" value
I'm using WinXPSP3 and FileMakerPro 9.
Any help is much appreciated!
This method works to update one field for all records in a found set. If you have multiple fields within the same record that you need to do this on, you'll need to repeat the following steps once for each field.
This method also assumes that the blank field is truly empty. If it contains invisible characters such as a space character it won't find the records with blank fields.
I just now realized I was taking about a field with radio-buttons, my apologies :-S
I wanted to change all non-selection of the radio button values to a certain radio button value. For example all "blanks" or non-selections to "Y" for yes.
So for my original question you actually correctly answered and I did learn how to do that in the event.
This can also be done for a radio button formatted field. You might temporarily place an edit box version of the field on a layout so that you can type an = into for performing your find.
Ah, light has been shed!
Retrieving data ...