I don't believe this is the purpose of Find/Replace. The step, I believe, is to find a text string and replace it with another. I.e. find apple and replace with pear. To accomplish what you want I would do a find for = as you did, then use SetField to enter x into the fields in the found set. In other words the Find/Replace step will not let you replace nothing with something.
Thanks for the response. However this makes the ease of populating a database for the first time very cumbersome. In previous versions of FM Pro (e.g. 12) I certainly could find a blank ("") in a given field and replace it with something. I have been using this function to quickly populate a new database with data for years and across multiple versions of FM.
In FM13 the find and replace function still recognizes blanks because in the dialog box that comes up before committing to the find/replace it will substitute an empty 'find' box with "" knowing that you want to find blanks and replace them with something....
In short, I think something has changed here from version 12 to 13 that needs to be fixed. After all, if i can use the find function to find empty cells, why on earth would I not be able to use find/replace to do same?
Thank you for the post.
I am unable to reproduce any difference in the functionality of Find/Replace after testing FileMaker Pro 11 (Advanced), FileMaker Pro 12 (Advanced), and FileMaker Pro 13 (Advanced).
Find/Replace does not find blanks in any FileMaker Pro version. I tested FileMaker Pro 11, 12, and 13:
1. Find for ""
2. Find for " "
3. Find for =""
4. Find for =" "
To my knowledge operators have never worked in the Find/Replace dialog nor finding for blanks.
Perhaps, I am missing a step to replicate?
Might you have used a Find, followed by Replace Field Contents to do this in the past?
Firstly many thanks to all who responded.
Secondly, duh! I get the 'dummy' prize for mixing up Find/Replace with making a 'Find' and then 'Replace Field' command.
Obviously my grey cells are depleting at an exponentially faster rate as I am reaching my 'sunset' years !
Thanks for helping out.