How to seperate look-up column values in each row in Microsoft List?

Question

Hello,

The new version of Microsoft List, for the lookup column, the values are now seperated by a colon "," by default (in the previous version, they are seperated in each row).

I would like to ask how we can set these values in order to display in each row?

Thank you.

Answer 1

Hi @Tran,Long_Thai (AH RA_PV_CO) BIA-VN-H ,

Thank you for posting in this community.

I tested this in my Microsoft List lookup column and they are separated in each row.

Does this happen with other lists? You could try to clear browser cache or use a different browser to see if the same error occurs.

After my search, maybe you can use javascript and jquery. The code replaces the html coding of a semicolon with a html line break. It then copies the code and replaces the orginal code with it.

$(document).ready(function(){
  $(".ms-vb:contains(';')").each(function(){
    var htmlstr = $(this).html();
    var htmlmod = htmlstr.replace(/; <A/g,"</br><A");
    $(this).html(htmlmod);
  });
});

Reference:https://sharepoint.stackexchange.com/questions/9042/replace-semicolon-delimiter-in-a-lookup-column-on-the-list-view

Hope the information can help you. And if there have any unclear or misunderstanding, please feel free to post back and we’ll continue to help you all the time!

Your understanding and patience will be highly appreciated! Hope you have a good day and keep safe!

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hi @Xyza Xue_MSFT

Thank you for your response. If the list is open in Sharepoint, the values are displayed in seperated rows. But if I open the list using Microsoft List app, it does not work.

Also, could you please instruct me in details on how to use the code you provided?

Thank you very much indeed.