Hi - so this is a slightly more complex case of a question asked here earlier.
Basically, if you pose a multi-select question in Qualtrics, you get a mutl-string variable that has values like:
1,2,6,7
Then in SPSS you need a way to parse this and create new dichotomous variables based on the substrings in the original variable.
Earlier a user helpfully supplied:
(COMPUTE [new variable name] = INDEX(POSFEED, "[substring]") > 0.
However, where I find this breaks down is where I have more than 9 answer choices. I have a question in Qualtrics that was mutli-select, with 14 possible choices. The problem is that the above syntax, if it is searching for ex. for the substring "1", then includes in the new variable not just occurrences of 1 but also occurrences of 10, 11, 12, 13, and 14.
How does one avoid this?
Thank you,
Tamar