How to Customize Custom Label data in formula field [closed]

Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 8 years ago.

I got a requirement to customize custom label data and display in a formula field.

Like i have custom label called Deal Users and data like. Robin,Rivera,Jose,opp,Dcosta,James

Now i want to display data like

 Robin

 Rivera

 Jose

 opp

 Dcosta

 James

How can I do this?

Adrian Larson · Accepted Answer · 2016-06-01 16:44:54Z

2

You can use SUBSTITUTE function to replace the , with a line break like below.

SUBSTITUTE('Test,Test1,Test2', ',',  BR() )

This would display as

Test
Test1
Test2

Adrian Larson♦

151k38 gold badges247 silver badges431 bronze badges

answered Jun 1, 2016 at 16:41

Bugude

3903 silver badges12 bronze badges

1

This is correct. Just replace 'Test,Test1,Test2' with the custom label like this where mylabel is a custom label with value Robin,Rivera,Jose,opp,Dcosta,James. SUBSTITUTE($Label.mylabel, ',', BR())
– Saroj Bera
Commented Jun 1, 2016 at 17:42

Add a comment |

1 Answer 1