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 previously displayed as:

  • Answer A|Answer B|Answer C|Answer D|

Will now show as:

  • Answer A
  • Answer B
  • Answer C
  • Answer D

For more information on how to create an ETO Results formula click here.

Did this answer your question?