Skip to main content

How to link values that include commas

  • December 1, 2020
  • 1 reply
  • 14 views

Hi there :slightly_smiling_face:

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?

1 reply

  • Author
  • Inspiring
  • December 2, 2020

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…