Display Comma Delimited Custom String List to Line Separated | Community
Skip to main content
K
KevinQu1
New Participant
April 16, 2021
Solved

Display Comma Delimited Custom String List to Line Separated

  • April 16, 2021
  • 3 replies
  • 896 views

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},", ","<br>")

valueformat=HTML

The "<br>" displays as text instead of being seen as code:

Bob<br>Mary<br>Sue

Any ideas/tips?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Doug_Den_Hoed__AtAppStore

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. <br>, <p>, <div>, \r\l, etc.)...or at least, all of those I've tried multiple times, over time.

Regards,

Doug

3 replies

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
April 22, 2021

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. <br>, <p>, <div>, \r\l, etc.)...or at least, all of those I've tried multiple times, over time.

Regards,

Doug

K
KevinQu1Author
New Participant
April 22, 2021

Bummer…but thanks!

K
KevinQu1Author
New Participant
April 22, 2021

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?

skyehansen
skyehansen
New Participant
April 16, 2021

erm... is this a multi-select dropdown list? (sorry, didn't understand the sentence about listing calculated data, at all...)

K
KevinQu1Author
New Participant
April 16, 2021

No, just data in a custom field. The calculated field is just set up to output the names with comma+space between them as a string.

Terms & ConditionsAccessibility statement

Loading footer...