topic Re: Replace Null Value - Field Calc, Python in Python Questions

Replace Null Value - Field Calc, Python

KeithSoRelle — Mon, 01 Oct 2018 18:13:19 GMT

Trying to replace a null value with the field calculator. I am have a script that appends multiple feature classes into one feature class. After each feature class appends I want to add a field calculateField_management (field calculator) statement run that makes all null values from a specific field into a string value.

I've tried a number of ways but have yet to get an expected result.

I have 2 values for in the field - Null, 'CFW' and need to replace Null with 'TAR'.

Then I will have 3 values - Null, 'CFW', 'TAR' and will need to replace Null with 'DEN'

I've been trying something along the lines of:

def myCalc(x)

if (x != 'CFW"):

return 'TAR'

else:

return 'CFW'

Should be simple but I haven't had much luck getting the expected response. Could use help on both field calculations.

Thanks,

-Keith

Re: Replace Null Value - Field Calc, Python

DanPatterson_Retired — Mon, 01 Oct 2018 18:17:47 GMT

if x is None:‍

do something

should work if it is truly none and not just an empty string

or to cover all bases (add more to the tuple if needed

if x in (None, "", " ", "nadda"):‍

do something

Re: Replace Null Value - Field Calc, Python

JoshuaBixby — Mon, 01 Oct 2018 18:22:00 GMT

You can use Python Conditional expressions, a.k.a., ternary operators, to accomplish this task on one line. Set the parser to Python and put the following in the expression box:

'TAR' if !Field! is None else !Field!‍

Swap !Field! above for your field.

Re: Replace Null Value - Field Calc, Python

KeithSoRelle — Mon, 01 Oct 2018 20:14:09 GMT

Worked well. Thanks for the help!