How to link values that include commas

Hi there :slight_smile:

I have a multiple select column (column A, not the primary key column) that includes values like:

Test A
Test B
Test, C

I use look up in another column to refer to column A. The output is:

Test A
Test B
“Test, C”

How can I display comma-containing records properly (without the quotation marks)? I found some references in this forum using roll-up instead of look-up, but that was not helpful for my case. Should I somehow parse it as a string first?

I found a work-around:

I changed the lookup column to a roll-up. Then I used

Substitute(arrayjoin(values), ‘"’,’’)

Found this workaround in another thread. Still wonder what would be the correct solution…

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.