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.

Please feel free to contact Customer Support if you need more information or additional assistance.

Did this answer your question?