Skip to main content
Level 2
September 14, 2018
Question

Reporting on Multi Select fields

  • September 14, 2018
  • 13 replies
  • 2506 views
When reporting on a Multi Select field is it possible to add a carriage return between each option? LIke in Char(10) in excel? Thanks Sharon Watt ANZCA
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

13 replies

June 28, 2019
Tricky One :) displayname=Systems List linkedname=direct namekey=Systems Effected textmode=true valueexpression=REPLACE({DE:Systems Effected},","," \ \ u000A") valueformat=HTML So you need to replace the commas in your string with the unicode character u000A. To escape into the unicode character you need two \ \ without a space. It will save as only one \ so you'll need to add back the second slash each time you edit to prevent the interpreter from inserting the line break in the text mode instead of in the column. Melinda Layten Technical Project Manager - API and Integration Workfront
Level 9
June 27, 2019
This article gives the codes - but i don't know the syntax to use these. Anyone can help by showing an example of how to use these in text mode. View this on Workfront > Benetta Perry APS
New Participant
February 27, 2019
Did you ever find a solution for this? I would like to do the same thing. :) Sheri Whitten Gordon Food Service