Recently one of our programmers cut and paste text from an external document to populate variables.
Here is an example. I can see that those single quotes pasted in are odd.
if paramn=26 then PARAM="My PAD makes me feel ‘not normal’";
I created an ADaM define that included this dataset, and typed in these same values into a codelist. But when we validated, something odd happened. Pinnacle had no problem with the values I typed into the codelist.
But the report cited values in the dataset that did not match the codelist, and displayed the dataset values without the bogus single quotes (squares below):
My PAD makes me feel not normal
SD0037Value for PARAM not found in (ADPADQOL Parameter) user-defined codelistTerminology
I think it’s a bad idea to just cut and paste from some questionable source into a text variable, and that is the problem. But I’d like to have a more concrete reason than that to state. Is there a certain character set that Pinnacle recognizes? Does it have a name? And these bogus characters are not part of that character set?
* Required Field