Skip to main content
Geographic Information Systems

Return to Question

Tweeted twitter.com/StackGIS/status/1458766475985141765
added 368 characters in body; edited tags; edited title
Source Link
Taras ♦
Taras ♦
  • 34k
  • 4
  • 73
  • 148

QGIS Insert first word of a Inserting words from field into a new column in QGIS

Is there any good expression to extract the first word of a field and put it into a new column? I I would like to create a new column without the numeric values and filter out words that are doubled. For example

This is what I wantintend to extract the word "Landwirtschaft 370; Landwirtschaft 390" and get "Landwirtschaft" asachieve

InputDesired output
Gebäude- und Freifläche Land- und Forstwirtschaft 13304Gebäude- und Freifläche Land- und Forstwirtschaft
Landwirtschaft 26Landwirtschaft
Gehölz 327Gehölz
Landwirtschaft 2219Landwirtschaft
Landwirtschaft 7318Landwirtschaft
Fließgewässer 37Fließgewässer
Landwirtschaft 574Landwirtschaft
Landwirtschaft 6619Landwirtschaft

Here is the result.attribute table of my layer

enter image description here

QGIS Insert first word of a field into a new column

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column without the numeric values and filter out words that are doubled. For example I want to extract the word "Landwirtschaft 370; Landwirtschaft 390" and get "Landwirtschaft" as the result.enter image description here

Inserting words from field into new column in QGIS

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column without the numeric values and filter out words that are doubled.

This is what I intend to achieve

InputDesired output
Gebäude- und Freifläche Land- und Forstwirtschaft 13304Gebäude- und Freifläche Land- und Forstwirtschaft
Landwirtschaft 26Landwirtschaft
Gehölz 327Gehölz
Landwirtschaft 2219Landwirtschaft
Landwirtschaft 7318Landwirtschaft
Fließgewässer 37Fließgewässer
Landwirtschaft 574Landwirtschaft
Landwirtschaft 6619Landwirtschaft

Here is the attribute table of my layer

enter image description here

deleted 1 character in body
Source Link
lesto
lesto
  • 327
  • 1
  • 7

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column with the first word only. Maybe I could use the space betweenwithout the numeric values and filter out words for an expression?that are doubled. For example I want to extract the word "Landwirtschaft 370; Landwirtschaft 390" and get "Landwirtschaft" (which isas the first word in this case)result.enter image description here

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column with the first word only. Maybe I could use the space between the words for an expression? For example I want to extract the word "Landwirtschaft" (which is the first word in this case).enter image description here

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column without the numeric values and filter out words that are doubled. For example I want to extract the word "Landwirtschaft 370; Landwirtschaft 390" and get "Landwirtschaft" as the result.enter image description here

added 8 characters in body; edited title
Source Link
Christophe P.
Christophe P.
  • 2.1k
  • 11
  • 23

QGIS Insert first word of a field into a new rowcolumn

Is there any good expression to extract the first word of a rowfield and put it into a new rowcolumn? I would like to create a new rowcolumn with the first word only. Maybe I could use the space between the words for an expression? For example I want to extract the word "Landwirtschaft" (which is the first word in this case).enter image description here

QGIS Insert first word of a field into a new row

Is there any good expression to extract the first word of a row and put it into a new row? I would like to create a new row with the first word only. Maybe I could use the space between the words for an expression? For example I want to extract the word "Landwirtschaft" (which is the first word in this case).enter image description here

QGIS Insert first word of a field into a new column

Is there any good expression to extract the first word of a field and put it into a new column? I would like to create a new column with the first word only. Maybe I could use the space between the words for an expression? For example I want to extract the word "Landwirtschaft" (which is the first word in this case).enter image description here

Source Link
lesto
lesto
  • 327
  • 1
  • 7