field-calculatorlabelingqgis
I need to label many items but in the table attribute field there are some char (#F) for every item that I have to delete.
The length of the description are not always the same.
I create a new field but I am not able to set the logic operation to do that.
Recent versions of QGIS support deleting Shapefile fields from the attribute table.
Enable editing and then you can edit the shapefile attribute table and multi-delete the columns you do not need.
As of QGIS 2.18, SpatiaLite layers have the "Delete Attributes" capability. (Check in Layer Properties | Metadata)
Previously:
It is not possible to directly delete a column in Sqlite and thus in SpatiaLite: http://www.sqlite.org/faq.html#q11. Therefore QGIS cannot offer this functionality. The alternative is to recreate the table.
BEGIN TRANSACTION;
CREATE TEMPORARY TABLE t1_backup(a,b);
INSERT INTO t1_backup SELECT a,b FROM t1;
DROP TABLE t1;
CREATE TABLE t1(a,b);
INSERT INTO t1 SELECT a,b FROM t1_backup;
DROP TABLE t1_backup;
COMMIT;
Best Answer
You can use the field calculator to update the column removing unwanted chars:
You can also use this directly in an label expression, if you do not want to delete the char from the record. You have a long list of string function for you convenience.