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.
[GIS] How to replace null values in attribute table ArcGIS 10.2
arcgis-10.2arcgis-desktopfield-calculatorfile-geodatabase
Related Question
- ArcGIS Desktop – Using File Geodatabase with Null Values in Field Calculator in ArcGIS 10.0
- [GIS] Arc is changing decimals!! My scale is set to 2, why do the numbers in the select by attributes-unique values have more decimals
- [GIS] Changing field type of Excel attribute table for a Join
- [GIS] Extracting only number from address in QGIS Attribute Table
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:
Additionally, if you want to replace NULL with an empty string just add these two statements: