nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Have to make a 0 values in table null

caseybok

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.

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

VinceAngelo

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

- V

JoeBorgione

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

SepheFox

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

JoeBorgione

Python uses None for the null value:

TomSellsted

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

SepheFox

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.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.