AnsweredAssumed Answered

Calculate Field with Python 3 / <Null> values

Question asked by jwolff on Sep 4, 2019
Latest reply on Sep 4, 2019 by LanceCole

I'm attempting to concatenate several fields, where one of the source fields is a double, the rest are string, and all of them have some <Null> values.  If I use the following syntax in Calculate Field in Pro 24.1/Python 3:

 

str(!AddrPrimaryHighNo!) + " " + str(!StreetPreDrctnAbbrev!) + " " + str(!StreetName!) + " " + str(!StreetSuffixAbbrev!) + " " + str(!StreetPostDrctnAbbrev!)

 

I get values like:

1498.0 None AVENUE K NONE NONE

 

where I would expect:

1498  AVENUE K

 

AddrPrimaryHighNo is Double

StreetPreDrctnAbbrev is Text

StreetName is Text

StreetSuffixAbbrev is Text

StreetostDrctnAbbrev is Text

 

If I perform the field calculation below in ArcMap 10.5.1/VB Script, it works out just fine:

 

[AddrPrimaryHighNo]&" "& [StreetPreDrctnAbbrev]&" "& [StreetName]&" "& [StreetSuffixAbbrev]&" "& [StreetPostDrctnAbbrev]

 

Meanwhile I'm just going to go back to ArcMap.  Thanks

-Justin

Outcomes