Convert list to comma separated string

jcjags63 · 2020-09-06T17:26:20.628Z

I currently have a list of addresses in my database formatted in a column and I would like to convert it into a comma-separated string so that I can call upon it for my Map app formatted like the following (without brackets):

[address 1],[address 2],[address 3]

This is what I currently have however it only pulls the first address from the list.

Jici · 2020-09-06T17:31:40.698Z

use :join with and add a comma

sudsy · 2020-09-06T23:28:54.752Z

jcjags63:

I would like to convert it into a comma-separated string

Being explicit, as @Jici recommends, is probably the best approach, as it allows you to choose the delimiter.

However, it’s worth knowing that Bubble will automatically convert a list into a comma-delimited string when that list is used in a string context (IF the data type comprising the list can be represented as a string).

So for instance, setting a text element to a list of images will result in a comma-delimited series of URLs. In your case, simply using the list of addresses in a string context will achieve your desired result.

SIDE NOTE: If any of the addresses contain commas - e.g. 123 45th Street, Unit B - that could result in unwanted side effects down the line, so beware. You might want or need to use something other than a comma as the delimiter.

jcjags63 · 2020-09-07T14:53:51.314Z

Thank you, I’ve got to go over the documentation but this worked perfectly.

pathomap · 2024-02-29T23:03:23.317Z

How do you convert a list to a string?

sudsy · 2024-02-29T23:20:26.681Z

Since the :format as text operator was introduced, it’s probably the best, most versatile way to go about it.