[GIS] How to replace null values in attribute table ArcGIS 10.2

arcgis-10.2arcgis-desktopfield-calculatorfile-geodatabase

I have a string field 'Oneway' with three values '+' '-' and Null showing a street accessibility, I would like to replace them with values 'F' 'T' and null as the script for Network dataset expect these values.However it seems that it is not possible to replace values if Null values are present. I tried also changing the field type to double or text but the field properties are not editable somehow (I tried this in arc catalog). I am only able to replace value '+' and '-' with numbers using the field calculator but need to replace them with letters.

Best Answer

An automated way of doing this task is by running a python function within Field Calculator (no selecting and reverse selecting required), see example below:

enter image description here

Additionally, if you want to replace NULL with an empty string just add these two statements:

elif value is None:
    return ''