Skip to main content
edited tags
Link
Babel
  • 74.9k
  • 15
  • 87
  • 227
Tweeted twitter.com/#!/StackGIS/status/463757135092781056
Source Link
mike
  • 1k
  • 13
  • 17

Is there an escape option for single quotes & apostrophes in QGIS?

I'm trying to use the Data Defined symbology in QGIS ver 2.2. Some of my data has single quotes/apostrophes.

Since the string must use single quotes, is there an escape option I can use for the field calculator or for the data defined settings field?

So, I'm trying to use something like this:

CASE
WHEN "NAME" = 'WILSON'S' THEN '0,75,224'
END

How do you build an expression around a string that may have a single quote or apostrophe?

Thanks. QGIS Valmiera 2.2 Windows 7 - 32 bit