Separate TouchPoint Values for Non-Exclusive Choice Elements on to Separate Lines

#Results #FlattenedData

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 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?