<div dir="ltr"><div><div>Thank Matthias for pointing this out ! Very handy indeed.<br><br></div>Cheers<br></div>Michaël<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-09-20 12:59 GMT+02:00 Matthias Kuhn <span dir="ltr"><<a href="mailto:matthias@opengis.ch" target="_blank">matthias@opengis.ch</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
Hi Phil,<br>
<br>
In addition to COALESCE I'd like to promote the use of the function
<b>CONCAT()</b> which treats NULL values as empty strings (it was
changed recently, it's probably since 2.10) what makes it very
handy.<br>
<br>
Example:<br>
<br>
NULL || "hello" -> NULL<br>
<br>
vs.<br>
<br>
CONCAT( NULL , "hello") -> "hello<br>
<br>
vs.<br>
<br>
COALESCE( NULL, "" ) || "hello" -> "hello"<br>
<br>
Cheers,<br>
Matthias<div><div class="h5"><br>
<br>
<div>On 09/20/2015 09:54 AM, Phil (The Geek)
Wyatt wrote:<br>
</div>
</div></div><blockquote type="cite"><div><div class="h5">
<div>
<p class="MsoNormal">Hi Folks,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">I am working with LIST Address Points data
from <a href="http://listdata.thelist.tas.gov.au/opendata/" target="_blank">http://listdata.thelist.tas.gov.au/opendata/</a>
(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.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Can someone give me a quick heads up on how
to NOT add the data from a field that has NULL?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Chances are I will be doing this regularly
so I am keen to document the required expressions for others
to use as well.<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span>Cheers
- Phil<u></u><u></u></span></p>
<p class="MsoNormal"><span><u></u> <u></u></span></p>
<p class="MsoNormal"><span>Volunteer
Mapper - <a href="http://www.redcross.org.au/volunteering.aspx" target="_blank"><span style="color:windowtext;text-decoration:none">Red Cross</span></a><u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><span class=""><pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank">Qgis-user@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</span></blockquote>
<br>
</div>
<br>_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></blockquote></div><br></div>