AnsweredAssumed Answered

Survey123: Split answers from multiple_select

Question asked by n.ueberschaeresri-rw-esridist Employee on Jan 20, 2020
Latest reply on Jan 21, 2020 by n.ueberschaeresri-rw-esridist

I am pretty sure that I saw this problem solved somewhere already but I cannot find it. 

Assuming that I have a multiple_select answer that has the selected answers concatenated by a comma: 

 

Banana, Apple, Orange, Strawberry, Tree_Tomato

 

Now I would like to save these answers to different columns (=questions) in my survey

 

First Answer: Banana

Second Answer: Apple

Third Answer: Orange

Fifth Answer: Tree_Tomato

 

How can I extract the answers separately depending on their position?

 

Alain Roland Munyaneza

Outcomes