<!DOCTYPE html><html><head>
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type">
<style type="text/css">body { font-family:'DejaVu Sans Mono'; font-size:12px}</style>
</head>
<body bgcolor="#FFFFFF" text="#000000">Am 21.09.2015, 08:39 Uhr, schrieb Andreas Neumann <a.neumann@carto.net>:<br><br><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex">... if you use capital
letters in field names (which is discourage anyway).</blockquote><div>Hi Andreas,</div><div>could you elaborate a little on why not to use capital letters for field names? Recently I started using capital letters for fields, cause for me, any expressions and codes becomes much better readable.</div><div>(Which also reminds me, that a lot of processing functions change field names to upper case or lower case or leave them as is, totally unconsistenly.)</div><div><br></div><div>Cheers</div><div>Bernd</div><div><br></div><blockquote style="margin: 0 0 0.80ex; border-left: #0000FF 2px solid; padding-left: 1ex"><br>
<br>
<br>
<div class="moz-cite-prefix">On 20.09.2015 12:59, Matthias Kuhn
wrote:<br>
</div>
<blockquote cite="mid:55FE9175.6040706@opengis.ch" type="cite">
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<br>
<br>
<div class="moz-cite-prefix">On 09/20/2015 09:54 AM, Phil (The
Geek) Wyatt wrote:<br>
</div>
<blockquote cite="mid:005301d0f379$8ca06a60$a5e13f20$@wyatt-family.com" type="cite">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";
mso-fareast-language:EN-US;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style>
<div class="WordSection1">
<p class="MsoNormal">Hi Folks,</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">I am working with LIST Address Points
data from <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://listdata.thelist.tas.gov.au/opendata/">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.</p>
<p class="MsoNormal"><o:p> </o:p></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?</p>
<p class="MsoNormal"><o:p> </o:p></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.</p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Cheers
- Phil</span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="mso-fareast-language:EN-AU">Volunteer
Mapper - <a moz-do-not-send="true" href="http://www.redcross.org.au/volunteering.aspx"><span style="color:windowtext;text-decoration:none">Red
Cross</span></a></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<br>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
</blockquote><br><br><br><div id="M2Signature"><div>-- </div><div>Bernd Vogelgesang<br>Siedlerstraße 2<br>91083 Baiersdorf/Igelsdorf<br>Tel: 09133-825374</div></div></body></html>