I have a shapefile with PID readings attached for each location. I would like to make all 0 values null. I have found a few sources pointing me in the right direction and to use the field calculator. My experience with VB script and python is minimal. Does anyone know what the formula would be? I would assume I would have to use the "replace" command, but not positive.
- 1 person found this helpful
Casey,
If you are using the Field Calculator in ArcMap, you can select the records = to 0 and just calculate the value to NULL
For instance:
Regards,
Tom
Python uses None for the null value:
- 1 person found this helpful
There's really no need to use python though, he could just use the default VB script.
- 1 person found this helpful
True; but since its 2015, there's more than one way to skin a cat......
- 2 people found this helpful
Except that the data format is shapefile, and dBase doesn't support numeric nulls, so the cat gets off lightly this time.
- V
Seems like people use the word shapefile just like Kleenex and BandAids, even though they are really using Puffs & NexCares.....
I hear you. If the shapefile is a "FGDB shapefile" or "shapefile in SDE", then the options for field calculation are improved.
- V
Just select by attribute, where the PID values = 0, and then right click the PID field --> field calculator, enter the word NULL into the box, and hit ok.