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.)