laptop and a wrench

Bug

The Replace All does not function in the attribute table when trying to convert a number to Null in the numeric type fields in ArcMap.

Last Published: August 16, 2019 ArcGIS for Desktop
Bug ID Number BUG-000111845
SubmittedFebruary 22, 2018
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.6
StatusWill Not Be Addressed

Additional Information

This is as designed. A better solution is offered in ArcGIS Pro's Find & Replace (in development now).

Workaround

A Python query can achieve this. However, this query only works on one field at a time.

In the Field Calculator, select the Python parser, and check the Show Codeblock check box.

In the Pre-Logic Script Code box, copy and paste the following code:

def updateValue(value):

if value == 0:

return None

else: return value

Type the following code in the second box, and replace '!Field_Name!' with the field name from the fields list, as required:

updateValue(!Field_Name!)

Steps to Reproduce

Bug ID: BUG-000111845

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options