Help

How to link values that include commas

Topic Labels: Formulas
498 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Felix_Fabich
6 - Interface Innovator
6 - Interface Innovator

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 1
Felix_Fabich
6 - Interface Innovator
6 - Interface Innovator

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…