Subject: Delimiter Between Multiple Choice Values in CSPro Data Export

[shafim0123]

Hi CSPro Forum family,

I have a query regarding multiple choice questions in my CSPro project. I have implemented multiple response questions, and the data is being collected correctly. However, when I view the data in the .csdb file or export it to STATA, I would like to have a delimiter (such as a single white space or a comma) between the selected responses for each multiple choice respnses.
for eg: if option A,B and C is selected its showing ABC without any delimiter. Is there any way to add delimiter in between responses.

Is there a way to automatically insert a delimiter between the selected values either within CSPro or during the export process to STATA?
Please help

[Gregory Martin]

Probably the best way to do this is to split your checkbox into separate variables. Read more about this in the workshop materials:

https://csprousers.org/mobile-workshop/ ... o%20Yes/No

Another way is to create a copy of your dictionary and use it for export. If you had a checkbox field like:

- FAVORITE_DRINK, alpha, item, length 16, occurs 1

You could change it to:

- FAVORITE_DRINK, alpha, item, length 1, occurs 16

Then you'll get 16 separate values output as part of the export process, one for each checkbox entry.

You can also do this by keeping FAVORITE_DRINK as an alpha and adding a subitem under it and then exporting the subitem:

- FAVORITE_DRINK, alpha, item, length 16, occurs 1
- FAVORITE_DRINK_EXPORT, alpha, subitem, length 1, occurs 16