Many thanks for all the suggestions - I will give them a try
Cheers - Phil From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Phil (The Geek) Wyatt Sent: Sunday, 20 September 2015 5:54 PM To: Qgis-user@lists.osgeo.org Subject: [Qgis-user] Concatenate address fields with NULLS Hi Folks, I am working with LIST Address Points data from http://listdata.thelist.tas.gov.au/opendata/ (Specifically Clarence Municipality) and I need to concatenate into one field the full address of each location. I am struggling to figure out how to do it when there are fields for unit numbers, building names, numbers to and from etc. Many of the fields are also NULL so clearly I want those fields disregarded. Can someone give me a quick heads up on how to NOT add the data from a field that has NULL? Chances are I will be doing this regularly so I am keen to document the required expressions for others to use as well. Cheers - Phil Volunteer Mapper - <http://www.redcross.org.au/volunteering.aspx> Red Cross
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user