What is the Formula to show Non-Exclusive Choice values from a TouchPoint element on separate lines within a table cell, instead of having them separated by pipes?
If in the Flattened TouchPoint folder, the Non-Exclusive Choice element has the corresponding Results Object, "[Question_X]", one could use the following Formula to remove pipes, and separate values by lines:
=Replace([Question_X];"|";Char(10))
Using this Formula, the values that were previously displayed as:
Answer A|Answer B|Answer C|Answer D|
Will now show as:
Answer A
Answer B
Answer C
Answer D
What is the Formula to show Non-Exclusive Choice values from a TouchPoint element with semi-colons, instead of having them separated by pipes?
This formula is useful for Touchpoint Batch Uploads!
=Replace([Answer];"|";";")