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
I have a column in a large attribute table. The values in this column are numeric value.
Example entries in this case would be:
1, 2.0512, 8.5744, 8.944
How can I add the word 'm' to the end of each entry so it'd look like:
1m, 2.0512m, 8.5744m, 8.944m
I don't want to use the technique of sorting them, then selecting them, then using field calculator to define them. I just want to know how to add text at the end of existing value, no matter what the existing value is.
If your original field is a string-type field, you can update it instead of creating a new field.
Use the Field Calculator to update an existing field
concat("oldfield", 'm')
If your original field type is numerical, you can't add text to it. Instead you have to add a new string-type field.
Use the Field Calculator to create a new field.
concat("oldfield", 'm')
*Substitute the actual name of your field where I used the value "oldfield"
str(!fieldname!) + 'm'. The general idea is that you need to convert the numeric value to string and then concatenate with another string. – smiller Aug 6 '18 at 15:58to_stringrather than the Pythonstr. But maybe it doesn't have an underscore, per the qgis documentation (look in conversions group) -- docs.qgis.org/2.8/en/docs/user_manual/working_with_vector/… – smiller Aug 6 '18 at 16:00