Concatenating fields in field calculator of QGIS?

Question

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

underdark · Accepted Answer · 2015-06-05T13:42:41.383

30

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

tostring(hectares) + ' ha'

Previously, the only concatenation operator was: ||

tostring(hectares) || ' ha'

edited Jun 05 '15 at 13:42

answered Jul 12 '11 at 12:02

underdark

84,148
21
231
413

score 12 · Answer 2 · answered Jan 06 '14 at 08:26

12

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.

answered Jan 06 '14 at 08:26

Benno

736
7
16

8

You can also concatenate directly with "field1" || "field2". – SAnderka Jan 06 '14 at 08:52
With || you can use all kinds of columns. Using concat(), you can only use strings. – Alexandre Neto Jan 06 '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 06 '14 at 10:44

score 8 · Answer 3 · answered Oct 31 '14 at 10:58

8

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

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

answered Oct 31 '14 at 10:58

nickislander

163
1
6

I suggest the readers use this solution rather than the popular solution to combine two integers. to_string("field1") || to_string("field2") – G.S. J Jun 23 '21 at 06:59

score 3 · Answer 4 · answered Mar 19 '13 at 19:43

3

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

answered Mar 19 '13 at 19:43

SkipCody

41
3

score 1 · Answer 5 · edited Oct 03 '13 at 01:25

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.

edited Oct 03 '13 at 01:25

Community

1

answered Jul 12 '11 at 11:39

Darren Cope

6,616
2
32
47

Concatenating fields in field calculator of QGIS?

5 Answers5

Linked

Related