How to fix a parcing error for field calculator?

HannahDodd

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)

JoshuaBixby

If by "put 3 fields together" you mean concatenate three fields with mixed data types, and possibly having NULL values, then try the following in the expression dialog box:

<SPAN class="string token">""</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>str<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>strip<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> <SPAN class="punctuation token">(</SPAN>!CSubdivision!<SPAN class="punctuation token">,</SPAN> !CBlock!<SPAN class="punctuation token">,</SPAN> !CLot!<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> i<SPAN class="punctuation token">)</SPAN>‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>