AnsweredAssumed Answered

Field Calculator for not null fields

Question asked by ingallbas on Nov 8, 2018
Latest reply on Jun 5, 2020 by bixb0012

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