Wednesday, 7 March 2018

field calculator - How to search text string and select item in QGIS?



I have a table attribute with complete roads name. I have to search items by digiting a part of the road name and I need to colour all the items selected.


eg: ROAD NAME: / road 01 / road 02 / road 11 / road 12


I need to colour all items that contain "1" (so all the items except the second one). I would like to set the string operator is this way: ROAD NAME ILIKE ' * 1 * ' but it does not work


edit I work in advanced search in table attribute



Answer



if the attribute is called ROAD NAME, the query should be


"ROAD NAME" LIKE '%1%'

No comments:

Post a Comment

arcpy - Changing output name when exporting data driven pages to JPG?

Is there a way to save the output JPG, changing the output file name to the page name, instead of page number? I mean changing the script fo...