AnsweredAssumed Answered

Field Calculator Combining Fields

Question asked by geonetadmin on Aug 6, 2013
Latest reply on Aug 12, 2013 by geonetadmin
Original User: M.P.N.Mark_RUG

Good day all,

I've got a question about the field calculator. I would like to combine several fields together in one, new field. (Street name, House number, Extension, Postal Code and Place). So my code looks like this (the fieldsname are in Dutch)

[Straatnaam]&" "&[Huisnummer]&[Huisletter]&" "&[Postcode]&" "&[Woonplaats]

After a couple of minutes, I get the result in my newly created field. However, not every streetname has a extension (Huisletter) and is left 'blank' in its original field, which results in an extra space in my newly created field.
How do I modify my code to include the number, but exclude the 'blank' cells?

Thanks in advance.