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:
[OrganisationName]& ", " & [BuildingName]& ", " & [BuildingNumber]& ", " & [Thoroughfare]& ", " & [PostTown]& ", " & [Postcode]
However this results in entries like:
, , 1, Example Street, Example Town, AB1 2CD
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 ", "?