expressionprint-composerqgisqgis-3
I have a column "name" and on it is contains several row like
I want to display names that only contain word "mall" on it, what is the formula for that filtering in QGIS?
You have a projection problem. The shapefile has a coordinate reference system (CRS) that is used as the units of measure in the geometry, and defined in the files PRJ. These need to match.
I suspect that you have added your data to QGIS. Then you went into properties-source and changed the CRS to WGS84. Below is a screen shot of some data using EPSG 2285. This is the CRS of the geometry and the PRJ of my original data.
Now if I go into properties - source I see the same CRS.
Of course you can change it to another CRS but you have just confused QGIS because you told it that the underlying geometry is referencing a different CRS. Any KML exports after this point will not display correctly.
Delete your KML. Start a new project. Add your shapefile and confirm the CRS. Save the file as a KML and only at that point define the CRS of the output KML as WGS84.
Best Answer
Case sensitive
Use this expression to evaluate if the field
"name"contains the stringMall(does not findmalletc.):"name" LIKE '%Mall%'or alternativelystrpos("name",'Mall')>0Ignore case of first character
Be aware that the above solution is case sensitive, finding
Mall, but notmall. To include both versions, use:regexp_match("name",('M|mall'))>0Ignore case completey
To find variants like Mall, mall, MALL, MAll, maLL, MaLl etc., use:
lower("name") LIKE '%mall%'or"name" ILIKE '%mall%'orregexp_match("name",'(?i:mall)')- see here for this last syntaxQGIS expression functions reference
See the help of the functions used here:
LIKEILIKEstrpos()regexp_match()lower()