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