Find and Replace Won't Replace......

Question

I am trying to replace a value in a selected field. When I do a find and replace I get an error that no fields have been detected. I have put in to find and replace it with the info that I want. I have selected the field but I still get this error. Can anyone help me with this? Is there a better or another way to do this? It just takes too long to select each field and type in the replacement info.

RichardFairhurst · Answer

You can use this Field Calculator expression to replace Null values in any field without preselecting records.  Of course it is limited to working on one field at a time.  This approach is not recommended for SDE version editing, but it is fine for file geodatabases and shapefiles.

Parser: VBScript

Prelogic codeblock:If IsNull() Then ' Substitute  with your real field name here
  Output = 0 ' Specify the replacement value for Null here. Make sure it is valid for the field you are calculating.
Else
  Output =  ' Substitute  with your real field name here
End If

Expression: Output

JoeBorgione · Answer

Or use the caveman simple approach and select is null. Then use the field calculator on the selected set such that = Your_Specified_Value.

RobertBorchert · Answer

Find and Replace cannot find nothing. You need to do a query using Select by Attributes. The use Field Calculator or the Attributes window to insert a value. NOW I do not recommend this. You can also open your database in MS Access. Open the table that contains the values you want to replace. Press Control H to bring up the Find Replace. Insert the word Null and have it match Whole Field. This way you can replace many thousands of null values with something. Now I must as why you want to get rid of the null values? Is it only because you do not want to see the null value but would rather have a blank space. Keep in mind when you replace a with a value you are increasing the size of your database and it could effect performance if you do enough of them. I am trying to replace a value in a selected field. When I do a find and replace I get an error that no fields have been detected. I have put in to find and replace it with the info that I want. I have selected the field but I still get this error. Can anyone help me with this? Is there a better or another way to do this? It just takes too long to select each field and type in the replacement info.