Replace Null Values - ArcPro

3058
1
04-24-2020 10:47 AM
BennyNein
New Contributor III

Hello. I'm a bit of a novice when it comes to Python. I'm sure there is a simple way to do this task, but I was hoping I could have someone explain it to me because the guides online aren't helping. I'm trying to replace null values with just an empty value in an attribute table. Not everything in the field is null, however. What occupies some of the values are a combination of letters and integers. For example, I have a value as 5a listed. All I want to do is replace those null values. I would appreciate any help. Thank you. 

1 Reply
JoshuaBixby
MVP Esteemed Contributor

Using Field Calculator and Python parser:

'' if !field! is None else !field!‍

where you replace field with your field name.

Another approach would be to use Select Layer By Attribute to select all NULL, and then use field calculator to update those selected records to empty string.