Skip to main content
Geographic Information Systems

Return to Question

added 9 characters in body
Source Link
Kadir Şahbaz
Kadir Şahbaz
  • 78k
  • 57
  • 257
  • 404

iI want to split a text column with city names by selecting only the names like 'world (planet)''world (planet)' and not like 'world planet''world planet'. Tried before with left( "Name", strpos( "Name" ,' '))left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) endcase when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this itsis a correct form of expression).Is Is there a way to split the names which is included the '()'? (imI'm new user in QGIS.)

i want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this its a correct form of expression).Is there a way to split the names which is included the '()'? (im new user in QGIS.)

I want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this is a correct form of expression). Is there a way to split the names which is included the '()'? (I'm new user in QGIS.)

deleted 11 characters in body; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

How to split a Splitting text attribute using conditional function QGIS 2.18.13

i want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this its a correct form of expression).Is there a way to split the names which is included the '()'? (im new user in QGIS.) thank you.

How to split a text attribute using conditional function QGIS 2.18.13

i want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this its a correct form of expression).Is there a way to split the names which is included the '()'? (im new user in QGIS.) thank you.

Splitting text attribute using conditional function QGIS 2.18.13

i want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this its a correct form of expression).Is there a way to split the names which is included the '()'? (im new user in QGIS.)

Source Link
indrit leka
indrit leka
  • 23
  • 2

How to split a text attribute using conditional function QGIS 2.18.13

i want to split a text column with city names by selecting only the names like 'world (planet)' and not like 'world planet'. Tried before with left( "Name", strpos( "Name" ,' ')) update existing field and results are fine only for the names 'world (planet)' but the other names like 'world planet' disappeared from column, So tried with conditional function case when 'names'like '%(%' then left( "Name", strpos( "Name" ,'')) end (if this its a correct form of expression).Is there a way to split the names which is included the '()'? (im new user in QGIS.) thank you.