How to separate each item and add in list?

[Aditya_Singh]

I have stored a list in a single cell in airtable which looks like:

(text1),(text2),(text3)

Now I am using Get cell block to get the cell data…But I want to store text1, text2 and text3 as 3 items in a list and remove brackets and commas.
Example:
text1
text2
text3

[techyguyhelp (Techy Guy)]

It’s easy.
First use the Replace All Text block to replace both kind of brackets with a blank text block.
Now use the split text at block to convert the text into a list

[Aditya_Singh]

Is this correct? I tried this but if I replace comma with blank text, then split at spaces is not working.

[Kanishka_Developer (Kanishka Chakraborty)]

Use the “select list item” block. Do not replace characters in a list to make it a string.

[Aditya_Singh]

So how can I convert the cell data into a list without replacing and splitting them first? Can you show me an example?

[Kanishka_Developer (Kanishka Chakraborty)]

The data you showed, with the brackets… Isn’t that a list?

---

@Aditya_Singh

replace comma with blank text

Replacing with " " without the quotes should solve it.

[yanquisalexander (Alexander Barrios)]

Parentheses not necessary

And you can use the “List from CSV record” block

[Aditya_Singh]

Yes there is a blank space in the split text at block. It is also working fine but commas are still there.

[Boban (Boban Stojmenovic)]

First use the Replace All Text block to replace both kind of brackets with a blank text block.
Now use the split text at block to convert the text into a list

You got your answer here already, you just need to interpret it correctly

/Boban

[Aditya_Singh]

Thank you. I did the same that you showed but my blocks were not arranged properly.

[Coder007 (S.H)]

https://community.kodular.io/t/how-can-i-format-this-to-list/35919

Can you look into this? I need little help to do this…