[Qgis-user] Concatenate address fields with NULLS

[Matthias Kuhn]

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 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/8b43a7b3/attachment.html>