Display Comma Delimited Custom String List to Line Separated

Question

I have a custom field list called "Managers" that lists calculated data as: Bob, Mary, Sue I want to display this data as: Bob Mary Sue I tried this via a simple HTML substitution, but that doesn't work: displayname=Managers textmode=true valueexpression=REPLACE({DE:Managers},", ","
") valueformat=HTML The "
" displays as text instead of being seen as code: Bob
Mary
Sue Any ideas/tips?

Doug_Den_Hoed__AtAppStore · Accepted Answer

Hi Kevin, For me, this was more a case of "if you can't say anything nice, don't say anything at all", but since you asked twice: "Nope" With the exception of hyperlinks, As Designed, Workfront lists strip out all of the html special characters that would otherwise allow such "new line" breaks (e.g.
,

,

, \r\l, etc.)...or at least, all of those I've tried multiple times, over time. Regards,Doug

KevinQu1 · Answer

It's unusual for y'all to be so quiet, so maybe I need to re-word my question:

I have a custom field that has a string of data separated by commas‚Ä¶

Joe, Sarah, Peter, Jane

But in reports, I have a request to display the data one per line, using the comma as a delimiter, to make it easier to read:

Joe

Sarah

Peter

Jane

Is there a way to use calculations/manipulations/tricks to make this happen?

Sign up

Login with SSO

Login to the community

Login with SSO