topic Re: Have to make a 0 values in table null in Data Management Questions

Have to make a 0 values in table null

caseybok — Wed, 08 Apr 2015 18:42:37 GMT

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.

Re: Have to make a 0 values in table null

SepheFox — Wed, 08 Apr 2015 18:53:26 GMT

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.

Re: Have to make a 0 values in table null

TomSellsted — Wed, 08 Apr 2015 18:54:24 GMT

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

Re: Have to make a 0 values in table null

JoeBorgione — Wed, 08 Apr 2015 18:58:17 GMT

Python uses None for the null value:

Re: Have to make a 0 values in table null

SepheFox — Wed, 08 Apr 2015 18:59:46 GMT

There's really no need to use python though, he could just use the default VB script.

Re: Have to make a 0 values in table null

JoeBorgione — Wed, 08 Apr 2015 19:05:11 GMT

True; but since its 2015, there's more than one way to skin a cat......

Re: Have to make a 0 values in table null

VinceAngelo — Wed, 08 Apr 2015 19:28:14 GMT

Except that the data format is shapefile, and dBase doesn't support numeric nulls, so the cat gets off lightly this time.

- V

Re: Have to make a 0 values in table null

JoeBorgione — Wed, 08 Apr 2015 19:39:47 GMT

Seems like people use the word shapefile just like Kleenex and BandAids, even though they are really using Puffs & NexCares.....

Re: Have to make a 0 values in table null

VinceAngelo — Wed, 08 Apr 2015 19:51:46 GMT

I hear you. If the shapefile is a "FGDB shapefile" or "shapefile in SDE", then the options for field calculation are improved.

- V