I have a large 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 ", "?