Splitting text responses

38d87d9852a66eea29da00ae16511664

Updated at October 22nd, 2019

Survey data sometimes has multiple answers combined into single strings with a delimiter. For instance, the Data Visualization Survey by Elijah Meeks asks respondents who they consider to be a thought leader.

Example

This was elicited as a multiple response section. But, the data shows the multiple responses catenated with a semicolon:


We might wish to see how often each person is mentioned overall, regardless of who else they might be mentioned with.

Split at delimiter

Press the blue edit icon for the field and select "Edit JSON...," Then add the attribute "split": ";"


The data is now separated by the delimiter and becomes a multiple-response element. Now we can see how often each person is mentioned individually:

Was this article helpful?