AnsweredAssumed Answered

Field Calculator for not null fields

Question asked by ingallbas on Nov 8, 2018
Latest reply on Nov 12, 2018 by KKramer-esristaff

I am trying to use the field calculator to concatenate various fields into one new field.  The ArcGIS Arcade Guide gives the following example

 

Concatenate(['red', 'blue', 'green'], '/')

which gives red/blue/green.  This works fine when all of the fields contain a value, but how can i concatenate only the fields that are not null

 

I am trying to concatenate address details , so for example 

 

field1 = building name

field2 = building number

field3 = road name

field4 = area

field5 = town

 

in my example the building name or area could be null, so i end up with:-

 

,12,A Road,,Town - so i need to remove the additional field separators ','

 

Thanks for any help

Outcomes