Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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

share|improve this question

1 Answer 1

up vote 4 down vote accepted

Using the escaping by simply doubling the single quote works for me:

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

Double quotes in the field value don't need escaping:

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

and I'm not sure if they are allowed in field names. Surely not in shapefiles.

Works at least on Windows.

share|improve this answer
    
brilliantly simple, thanks! –  mike May 6 at 18:38

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.