Replace comma delimiter in a multi-select choice column

Question

A SharePoint list has a multi-select choice field.

When 2 or more values are selected for an item,it is displayed(in the view)as:

Value1,Value2,Value3,Value4,Value5,Value6

Is there a way that I can display this field as shown below?

Value1,
Value2,
Value3,
Value4,
Value5,
Value6

Are you 2013? Then look into CSR - ClientSideRendering – Danny '365CSI' Engelman Aug 07 '15 at 13:00 — Danny '365CSI' Engelman, Aug 07 '15 at 13:00
@DannyEngelman No,I'm in 2010 – George Aug 07 '15 at 13:01 — George, Aug 07 '15 at 13:01

James Flattery · Accepted Answer · 2015-08-07T15:28:35.647

3

This should do it:

Download jQuery and save it to /SiteAssets/
Create a JavaScript file named comma-break.js and save it in /SiteAssets/ with the contents of:

$(document).ready(function () { var str = $('.ms-listviewtable').html(); //; $('.ms-listviewtable').html(str.replace(new RegExp(", ", "g"), ",</br>")); });

Add a Content Editor Web Part to your list and link to the jquery.min.js file.
Add a Content Editor Web Part to your list and link to the comma-break.js file.

edited Aug 07 '15 at 15:28

answered Aug 07 '15 at 12:01

James Flattery

307
2
16

also I assumed in that code, that you meant semi-colon instead of colon. If you in fact meant colon than just replace the two semi-colons in the code with colons. – James Flattery Aug 07 '15 at 12:06
when i tried your script,the field value became invisible. – George Aug 07 '15 at 12:29
Sorry about that! I should have verified the code before submitting. I updated the code and it appears to work for me. Please let me know if you have any problems. – James Flattery Aug 07 '15 at 13:34
You may want to change </a>; to , and </a>;</br> to ,</br> The list I was originally playing with was a multi-lookup select instead of just a multi-select. – James Flattery Aug 07 '15 at 13:50
I have the below script now and its not working. $(document).ready(function(){ var str=$('.ms-listviewtable').html(); //; $('.ms-listviewtable').html(str.replace( new RegExp(",","g"),",")); }); – George Aug 07 '15 at 14:30
Give me a moment to review. – James Flattery Aug 07 '15 at 14:56
So the script I commented is right? do i need to include any other js files? – George Aug 07 '15 at 14:58
Yes, ok the problem is you also need jQuery for the code I provided. I have updated my answer which should solve the issue. – James Flattery Aug 07 '15 at 15:22
Let us continue this discussion in chat. – James Flattery Aug 07 '15 at 16:52

Replace comma delimiter in a multi-select choice column

1 Answers1

Linked