topic Re: Editing Fields Back to <Null> in Data Management Questions

Editing Fields Back to

ChristinaDeFrancesco — Thu, 24 Oct 2013 15:01:03 GMT

Hi all,

I have a set of data with some fields in the Attributes Table that default to <Null>. If I edit a particular field, then try to set it back to a no data cell, the cell value is no longer <Null> but simply blank. How do I change my field cell back to <Null> so I can run a query (for Null values) on it? I am using ArcGIS for Desktop 10.1 SP1.

Thanks!
Christina

Re: Editing Fields Back to

TimWitt — Thu, 24 Oct 2013 15:11:02 GMT

Christina,

Can't you just select the records you want to be null, the right click the column and use the field Calculator and Calculate them using "null" (without the quotes) ?

Tim

Re: Editing Fields Back to

ChristinaDeFrancesco — Thu, 24 Oct 2013 15:25:49 GMT

Hi Tim,

I'm not sure how to select specific cells vs an entire row or column. In playing around with your idea, my edit session will only allow me to select an entire column. Also, when I tried the Field Calculator ([Field]="Null") it left my <Null> cells the way they were, and any cell that contained information was assigned a number (0) so still not the <Null> value I'm looking for.

I have tried simply changing the cell to a text "<Null>" but the query I'm running (currently on Symbology to display a value based on a <Null> option but I would also like to display data based on a definition query- [Field] IS NOT NULL) but it seems the text "Null" is not read by ArcGIS the same way as the coded <Null>.

I hope this all makes sense!

Re: Editing Fields Back to

TimWitt — Thu, 24 Oct 2013 15:40:36 GMT

Christina,

you need to write null without the quotations in the expression box (i.e. [Field]=null) . This will set your fields to <Null>.
Also even though it selects your entire row, it will only calculate the Attribute Field, where your right clicked its heading and chose Field Calculator.

Tim

Re: Editing Fields Back to

ChristinaDeFrancesco — Thu, 24 Oct 2013 18:24:37 GMT

Hi Tim,

I see what you're saying- that works beautifully. I'm wondering, however, if there is a way to do this same technique on only single cells at a time? I have 400+ data points, from which I only want a select few cells in a field column to change to Null; if I changed an entire column I would have to go back and re-enter data in cells that need data. Any thoughts on a more cell-specific technique?

Re: Editing Fields Back to

TimWitt — Thu, 24 Oct 2013 18:31:20 GMT

In your attribute table you can select the row you would like to change a cell in. Ctrl +left click the grey square all the way to your left, of your desired row. Repeat that for each row you would like to change a cell in. Once you have selected all the rows you would like to change to <null>, perform the field calculation outlined above. This will only calculate the cells of your collected row.

Re: Editing Fields Back to

ChristinaDeFrancesco — Thu, 24 Oct 2013 18:40:48 GMT

Tim,

This is perfect! Thank you!

Re: Editing Fields Back to

TimWitt — Thu, 24 Oct 2013 18:42:43 GMT

No problem! Don't forget to mark the post that answered your question by clicking the greyed out question mark to the right of it!

Re: Editing Fields Back to

ChristinaDeFrancesco — Thu, 24 Oct 2013 18:50:27 GMT

Oops, I'm not sure I can do that since when I originally created this thread I designated the Discussion type rather than Question.

Re: Editing Fields Back to

TimWitt — Thu, 24 Oct 2013 18:52:46 GMT

Don't worry about it, upvoting the helpful posts will also show a person with the same problem how to solve this problem. 🙂