Apostrophe in not working proerly in the expression

[#1]

Hi All,

I am facing one issue in one of the expression because of the apostrophe in the filed value.

Expression used  in qvw: ='[PD.Coverage] ={"$(=only([%PD.PD.Incumbent]))"}'

PD.Coverage & %PD.PD.Incumbent are the field names in qvw file. This above expression is using as a part of set analysis in some other expression.

This expression is working fine for all the values in %PD.PD.Incumbent field except the values with apostrophe (eg: Workers’ compensation)..

The expression is getting terminated whenever it come across ‘ value and its causing the issue.

Can anyone please help me how to handle this apostrophe value in the expression.

Thanks

Nirmal.

[ThornOfCrowns]

There are no escape characters in QV as far as I know, so you can't use "'" for example. You can substitute chr(39) for any single quote as a workaround.