Skip to main content
All CollectionsHelp ArticlesReporting in ETOFunctions and Formulas
ETO Results | Formula: Display Non-Exclusive Choice Elements
ETO Results | Formula: Display Non-Exclusive Choice Elements

BO 4.3 Platform

Updated over a week ago

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];"|";";")


โ€‹

Did this answer your question?