topic Re: Field Calculator Combining Fields in Geoprocessing Questions

Field Calculator Combining Fields

Anonymous User — Tue, 06 Aug 2013 09:18:27 GMT

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.

Re: Field Calculator Combining Fields

Anonymous User — Tue, 06 Aug 2013 11:27:38 GMT

Original User: mdenil

It seems that Huisletter sometimes contains a space character instead of an empty string.
A true empty string would not add space to your concatenated string

In your pre-logic block, test Huisletter for a single space
If it is a space set a variable to an empty string
if Huisletter is anything else, assume it is the actual Huisletter, and set the variable to the Huisletter value.

now build your concatenated string using the variable instead of Huisletter.

Re: Field Calculator Combining Fields

RichardFairhurst — Tue, 06 Aug 2013 11:41:19 GMT

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.

Here is the easy way to do it.

[Straatnaam] & " " & Trim([Huisnummer] & [Huisletter]) & " " & [Postcode] & " " & [Woonplaats]

Re: Field Calculator Combining Fields

Anonymous User — Tue, 06 Aug 2013 21:19:26 GMT

Original User: dmhoneycutt

For everyone's future reference, there's a blog post about combining (concatenating) fields:
Concatenating field values using Calculate Field

Re: Field Calculator Combining Fields

curtvprice — Sun, 12 Dec 2021 03:27:05 GMT

Here is the easy way to do it.

[Straatnaam] & " " & Trim([Huisnummer] & [Huisletter]) & " " & [Postcode] & " " & [Woonplaats]

I think it's even easier in Python. I am probably biased though...

"{0} {1} {2} {3}".format(
  !Straatnaam!, (!Huisnummer! + !Huisletter!).strip(), !Postcode!, !Woonplaats!)

Re: Field Calculator Combining Fields

Anonymous User — Mon, 12 Aug 2013 07:36:47 GMT

Original User: M.P.N.Mark_RUG

Here is the easy way to do it.

[Straatnaam] & " " & Trim([Huisnummer] & [Huisletter]) & " " & [Postcode] & " " & [Woonplaats]

Well, sometimes the easiest way is the best way. I forgot about adding the trim function. Thank you very much.

Also PMdmhoneycutt, thank you for that blog. I saw some excellent stuff there.