I have field values that are:
- OG_S_G2, etc.
and I want to change the OG to LIP whilst keeping all the text after (i.e. LIP_S_G4), is there a way to do this?
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
You can add a new column using the field calculator in the attribute table of your data.
Using the following code you can add new data labels based on existing ones.
CASE WHEN "column_name"= 'OG_SG4' THEN 'LIP_S_G4' WHEN "column_name"= 'OG_SG3' THEN 'LIP_S_G3' WHEN "column_name"= 'OG_SG2' THEN 'LIP_S_G2' END
Make sure that you set the correct output field type, in this case "Text (string)".