Skip to main content

Hi!


I have a rollup field (using ARRAYUNIQUE) that should always produce a single array value.


I want to pretty it up and remove the encompassing quotation marks, but I can’t seem to figure it out.


I’ve tried all of the following formulas, but none of them seem to work.


SUBSTITUTE({Vendor Rollup}, '"', '')



SUBSTITUTE({Vendor Rollup}, '/"', '')



SUBSTITUTE({Vendor Rollup}, """, "")



SUBSTITUTE({Vendor Rollup}, "/"", "")

Can anyone help me shed some light on my issue?


There’s a chance your rollup is coming in as array. You can turn it into a string by adjusting your formula like so:


SUBSTITUTE({Vendor Rollup}&"", '"', '')

There’s a chance your rollup is coming in as array. You can turn it into a string by adjusting your formula like so:


SUBSTITUTE({Vendor Rollup}&"", '"', '')



That worked! Thank you so much.


But why did it work (if you’d be so kind to explain)?


That worked! Thank you so much.


But why did it work (if you’d be so kind to explain)?


adding &"" to the end of a Rollup turns it into a string (text as opposed to an array), and SUBSTITUTE() can only work with text/numbers and not arrays. You could also accomplish all this from within the Rollup itself and do away with your formula by doing something like:


SUBSTITUTE(ARRAYUNIQUE(values)&"", '"', '')

or

SUBSTITUTE(ARRAYJOIN(ARRAYUNIQUE(values)), '"', '')

Reply


Terms & Conditions