AnsweredAssumed Answered

Merge Address Fields into one...

Question asked by terrafirma_theo on Dec 11, 2017
Latest reply on Dec 13, 2017 by Dan_Patterson

Hello.

I have a large (20+ million) address database point FC in FGDB format. Each address record is split into multiple fields like 'organisation', 'building name', 'building number', 'post town', 'post code' etc. Not every field is populated with data, there are many null values (not every address has an 'organisation' name for example).

 

I've created a new text field called 'Full_Addr' which will merge all the address fields into one. So far I used this VB script in field calculator:

 

Full_Addr=

[OrganisationName]& ", " & [BuildingName]& ", " & [BuildingNumber]& ", " & [Thoroughfare]& ", " & [PostTown]& ", " & [Postcode]

However this results in entries like:

, , 1, Example Street, Example Town, AB1 2CD

or

Example Organisation, , , Example Street, Example Town, AB1 2CD

 

Is there a smarter, more efficient way of creating a merged address field without the double, triple or quadruple ", "?

Outcomes