Parsing a list in a Database

danielgage4 · 2025-01-29T19:40:43.015Z

Hey guys! I am a new user of bubble and learning the platform. I have watched a bunch of videos and looked for a answer regarding this but have had zero luck fixing it. Basically my api call brings in a list of texts, numbers and dates. These lists are seperated by a comma but still in on row of the database. Like so

image1086×182 4.35 KB

I was hoping to find a way to either seperate them as they are being called by the API or parse though afterwards and seperate them into another database. Thanks for the help!

prosto.duda · 2025-01-29T19:49:56.180Z

Use Bubble’s :split by function to split the text by commas.
Save the resulting list of texts, numbers, or dates into their respective fields.

danielgage4 · 2025-01-29T19:57:26.059Z

I have tried using that split by where I have fields that are text like so:

image325×142 3.71 KB

But that did not change anything. I also can not use split by on dates or number fields only text. Unless I am missing something

prosto.duda · 2025-01-29T23:07:55.913Z

for dates, numbers. you need first convert to text.
if it is not change anything issue can be in saving, it is not clear what you want to do. you can debug your issue or show more details, plus I suggest use some alert to show in what result you have after split.