14

Is there a way to concatenate fields in field calculator of QGIS? (e.g. hectares + ' ha')

22

In recent QGIS versions (>= 2.6), + works for string concatenation

tostring(hectares) + ' ha'

Previously, the only concatenation operator was: ||

tostring(hectares) || ' ha'
8

Right-Click on the layer -> Properties -> Labels Then you can use the following function "concat(string1, string2,... ) : enter image description here

I hope it will be usefull.

  • 6
    You can also concatenate directly with "field1" || "field2". – SAnderka Jan 6 '14 at 8:52
  • With || you can use all kinds of columns. Using concat(), you can only use strings. – Alexandre Neto Jan 6 '14 at 10:04
  • 2
    I usually prefer at least a blank as separator: "field1" || ' ' || "field2". Splitting the label in two lines is also possible by defining a line separator like /n. – AndreJ Jan 6 '14 at 10:44
5

You can also append text or put spaces between using alternate quotations:

 "Streetnum" || ' ' || "Streetname"
3

You can use tostring() to concat number fields Ex hectares || ' ha' || tostring(id)

1

Yes! Using the field calculator, the syntax is: FIELDNAME || FIELDNAME

EDIT: This works on string fields or string-integer combinations. With Integers, it will just perform the math and add the fields together.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.