Organize Database from Commas to new lines/items

Need help Database
1

Hello Bubble contributors and supporters,

I have a little issue that I cannot figure out maybe one of you would know the answer.
I have received info from an API call, the info is comma separeated in the same item line like in the post attached below;

image
image958×470 89.2 KB

there are 2 things I would like to solve from here:

1st. How can I organize this info in a way that each institution is in a different line in the database instead of all of it being grouped in the same box in the database.

2nd. In case I decide to not sepparate the info in the database with different lines how can I sepparate the info in repeating groups so each cell has its own institutiton with its own image and link if all the info is packed in the same box?

Any help would be appreaciated it.

Bests,

Pablo

2

Did I manage to solve it? I’m also facing this problem.

3

You can just use the :split by operator and put ‘,’ as your delimiter.

I must advise against how @pablo4 is managing his database. With every field being a list, that’s just asking for trouble down the road.