Thank Matthias for pointing this out ! Very handy indeed. Cheers Michaël
2015-09-20 12:59 GMT+02:00 Matthias Kuhn <matth...@opengis.ch>: > Hi Phil, > > In addition to COALESCE I'd like to promote the use of the function > *CONCAT()* which treats NULL values as empty strings (it was changed > recently, it's probably since 2.10) what makes it very handy. > > Example: > > NULL || "hello" -> NULL > > vs. > > CONCAT( NULL , "hello") -> "hello > > vs. > > COALESCE( NULL, "" ) || "hello" -> "hello" > > Cheers, > Matthias > > > On 09/20/2015 09:54 AM, Phil (The Geek) Wyatt wrote: > > 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 - Red Cross > <http://www.redcross.org.au/volunteering.aspx> > > > > > _______________________________________________ > Qgis-user mailing > listQgis-user@lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user > > > > _______________________________________________ > Qgis-user mailing list > Qgis-user@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/qgis-user >
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user