AnsweredAssumed Answered

How to fix a parcing error for field calculator?

Question asked by hmdodd on Dec 19, 2016
Latest reply on Dec 19, 2016 by bixb0012

I am trying to put 3 fields together with no spaces and some of them are null. I tried the following expression: !AssetID!.replace("zero", str(!CSubdivision! + !CBlock! + !CLot! ))

If any of the fields are null, then the AssetID field also ends up null. I am trying to find a way around this and this is what I've come up with so far. I get keep getting a parcing error and I don't understand why. Can I return an expression? If not, how would I go about getting rid of the null values without changing my data?

(I'm using 10.4)

Outcomes