# From text with comas, to list in bubble workflow

**URL:** <https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053>\
**Category:** Database\
**Created:** [July 30, 2023, 5:58pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053 "2023-07-30T17:58:42Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 30, 2023, 5:58pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/1 "2023-07-30T17:58:43Z")

</div>

Hello, I need help regarding the types, I have a list in a text (this is the output of an API), it is like “word1, word2, word3, word4…wordN” I would like to add each word to a list in bubble.  
Like Word\_list: word1 (first item), word2, word3 … wordN

Is there an easy way to do it ?  
I saw a post where they said to use extract with regex “[^,]+” but for me it does not work, I can’t access the word1 as the first element of a list, but it puts all the words in the first element

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [July 30, 2023, 6:01pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/2 "2023-07-30T18:01:57Z")

</div>

`split by: , ` (comma space)

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 30, 2023, 11:52pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/3 "2023-07-30T23:52:15Z")

</div>

hello, yes I tried, it does not work either !

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [July 30, 2023, 11:58pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/4 "2023-07-30T23:58:14Z")

</div>

I can _assure_ you, 100%, it works.

(if it doesn’t work for _you_, you must be doing it wrong).

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 31, 2023, 2:46am UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/5 "2023-07-31T02:46:47Z")

</div>

yes that is why I ask here if there is no other solution, the split by: , is the first stuff I tried, but to no avail… I don’t know what I can do wrong, I use a personal api you can try, contact me in dm

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 31, 2023, 2:55am UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/6 "2023-07-31T02:55:27Z")

</div>

![Capture d’écran du 2023-07-31 04-54-41](https://us1.discourse-cdn.com/bubble/original/3X/7/5/75d06d23dc73b69261c1b141bd85733e6c60abdb.png)  
 ![Capture d’écran du 2023-07-31 04-53-40](https://us1.discourse-cdn.com/bubble/original/3X/2/0/20f814c296d9cbb794899554934e9443d59ec6a5.png)  
 ![Capture d’écran du 2023-07-31 04-53-11](https://us1.discourse-cdn.com/bubble/original/3X/3/8/38dbb286bb61d9d94d236fe4dc9a8d57d381c25d.png)  
it should be ‘fourtoutici’ in title not the full list of gardbage

---

<div class="post-metadata">

**Author:** ![animisha45](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/animisha45/32/224436_2.png) [@animisha45](https://forum.bubble.io/u/animisha45)\
**Post date:** [July 31, 2023, 4:54am UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/7 "2023-07-31T04:54:47Z")

</div>

For the Title, I would write something like this: expression: split by(, ): frst item.

This would ensure only first item gets added after the split.

---

<div class="post-metadata">

**Author:** ![adamhholmes](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/adamhholmes/32/100510_2.png) [@adamhholmes](https://forum.bubble.io/u/adamhholmes)\
**Post date:** [July 31, 2023, 7:04am UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/8 "2023-07-31T07:04:46Z")

</div>

You’re telling it to add the whole list as a single text… which is exactly what it’s doing (i.e. you’re doing it wrong)

If you only want the first item added, then you need to use split by , : first item.

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 31, 2023, 3:03pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/9 "2023-07-31T15:03:38Z")

</div>

this is exctly what i’m doing guys,  
title = xml\_title\_temp: split by (,) : first item

xml\_title\_temp = “fourtoutici, fourtoutici upload, click…”  
I should have : title = “fourtoutici”

---

<div class="post-metadata">

**Author:** ![georgecollier](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/georgecollier/32/182327_2.png) [@georgecollier](https://forum.bubble.io/u/georgecollier)\
**Post date:** [July 31, 2023, 3:05pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/10 "2023-07-31T15:05:44Z")

</div>

Send a screenshot because that would work if what you’re telling us is correct.

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 31, 2023, 3:41pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/11 "2023-07-31T15:41:55Z")

</div>

![Capture d’écran du 2023-07-31 17-37-13](https://us1.discourse-cdn.com/bubble/original/3X/1/4/14577074c44decfb881c9abef061b3ddcb8213b2.png)  
In fact the pb I have, and where you can help me the most to understand is that:  
the “titles” field of the API is a liste of words 'word1, word2, word3…" that I want to turn into a list in Bubble, but as you can see I dont have ‘spilt by (,)’ choice here, before I stored it in a variable ‘xml\_title\_temp’, but when i try to ‘split by (,)’ directly I can’t, I can only do ‘each item : split by…’ which is different.

---

<div class="post-metadata">

**Author:** ![klovistore](https://avatars.discourse-cdn.com/v4/letter/k/35a633/32.png) [@klovistore](https://forum.bubble.io/u/klovistore)\
**Post date:** [July 31, 2023, 3:46pm UTC](https://forum.bubble.io/t/from-text-with-comas-to-list-in-bubble-workflow/275053/12 "2023-07-31T15:46:11Z")

</div>

Well it does not split by  
 ![Capture d’écran du 2023-07-31 18-23-59](https://us1.discourse-cdn.com/bubble/original/3X/6/9/69b32df998000628bd9ae1b7e0ba805ab6f06efb.png)  
 ![Capture d’écran du 2023-07-31 18-24-13](https://us1.discourse-cdn.com/bubble/original/3X/8/5/850b687fc32876b9f44b2e13d1417604b3ff2efb.png)  
 ![Capture d’écran du 2023-07-31 18-24-26](https://us1.discourse-cdn.com/bubble/original/3X/e/a/eacfba30b54e040f48132a2dc901cd580aa699b2.png)
