[Qgis-user] Concatenate address fields with NULLS

[kimaidou]

Thank Matthias for pointing this out ! Very handy indeed.

Cheers
Michaël

2015-09-20 12:59 GMT+02:00 Matthias Kuhn <matthias at 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 at lists.osgeo.orghttp://lists.osgeo.org/mailman/listinfo/qgis-user
>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150920/82a313f8/attachment.html>