Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 17, 2019 08:39 AM
Currently I have a field that contains multiple products separated by commas.
Is there a way to “find” all commas and “replace” them with the “/n” line break?
I would like the product field which currently looks like this
“product1, product2, product3, product4”
to appear in the field as
product1
product2
product3
product4
Is there a way to do this?
Sep 21, 2020 06:57 PM
The roll up field is using
ARRAYJOIN(values)
and the field that is suppose to make it human readable is using
SUBSTITUTE({Items Purchased},",","\n")
If I make it ArrayUnique then I get an error in the Substitute field
Sep 21, 2020 07:59 PM
@Opher_Yunger Are you using a rollup field and want each unique value on its own line? If so, try this formula in the rollup:
ARRAYJOIN(ARRAYUNIQUE(values), "\n")
The inner ARRAYUNIQUE
returns only unique values. Then ARRAYJOIN
joints the values into a text string joined with the specified character.
Sep 22, 2020 11:18 AM
That was way easier. Thanks so much!
Is there a way to Alphabetize the Array?
Sep 22, 2020 12:13 PM
No, there is no array function to sort an array. The elements are in the same order as the linked record field itself. You can alphabetize the linked records according to the primary field for the linked records using the bulk update block/app.
Jan 08, 2022 02:42 AM
@kuovonne I have the opposite challenge! I’d like to get a text field with URLs that now looks like this:
https://www.google.com,
https://www.facebook.com,
https://www.amazon.com
Which I’d like to replace the “,” with a “;” like this:
https://www.google.com;
https://www.facebook.com;
https://www.amazon.com
Super simple I’d say but its seems to behave differently than excel/numbers…
May 12, 2022 07:58 PM
I’ve been looking for this solution for ages. Thanks so much. You are and always will be a superstar!