Help needed: Checking a string with single quote in program rule...

Hi all.

Kindly assist me to resolve this issue.

I want to check a single quoted string in a program rule such as “variable == ‘Don’t know’”. I tried using two single quotes (Don’'t know) and escaped with a backward slash (Don’t know) but it doesn’t work.

Any suggestions? Your help is very much appreciated.

Thanks and regards.

MSP

Hi MSP

I am not sure how to rectify the problem directly, but several easy solutions would be to simply reword the response to: ‘Unsure’, ‘unknown’, ‘not known’ or similar.

Kind regards,

Terence

···

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

Hey MSP - escaping single quotes is not supported as of now, it would be great if you create a feature request for it.

As Terence says, there might be workarounds - one suggested below. If “don’t know” is one of the options in an option set, I am guessing that there is a code for this option value - hopefully the code is without a quotation mark. If this is the case, open the program rule variable in maintenance and select “use code for option set”:

When this is checked, you can possibly rewrite your rule to check for the option instead:

#{variable} == ‘OPT_DONT_KNOW_CODE’

Markus

···

Terence Scott

Global Alliance for Rabies Control (GARC)

Pan-African Rabies Control Network (PARACON) Steering Committee

terence.scott@rabiesalliance.org

https://paracon.rabiesalliance.org

Skype: tpscott1987

Thank you very much Terence and Markus, for your valuable suggestions.

I am not sure whether the first suggestion can be implemented since we have already migrated 1000’s data with these values.

The second suggestion, using the code sounds good for me. Let me check the design and see what I can do.

Thanks once again for sparing your valuable time to respond.

image

···

Thanks and regards

MSP