How to separate this merged list of data after run query in SQL lite

[Zia_Choudhary (Zia Ur Rahman)]

i am using SQL lite extension link is here Yet another SQLite extension (Free)

when i get data from database i receive data like

Explanation want to get this merged data into separate form
here in screenshot in list view u see that data is like [ria,2] actually ria is from one column and 2 is id and it is from another coloumn
instaed of showing data from a single coloumn at one index it is showing data from both columns

Blocks

Result

Note
i have tried following methods but not worked
Blocks

Result

*explanations it is still not what i want… I want to get names data separatly and id list (if i want to show only id in list view)
Mean i want to get data of these name and id lists separately and want to show the respective on demand

[nikzdreamer2001 (Nikhil Kumar Gupta)]

use this block it will split text into lists using sepator…

[Zia_Choudhary (Zia Ur Rahman)]

See

@Zia_Choudhary

Blocks

I used it but not worked

[Rogerio_Rios (Professional Support)]

Try, before changing the “[ ]”, to change space with a delimiter /; -, then change the " [ ]". Now split in the delimiter you entered. (/ ; -)

[nikzdreamer2001 (Nikhil Kumar Gupta)]

Just store spilitted list into 3rd variable named xyz.

Now where splitting occurs just add 1st element of xyz to another list abc and second element to jkl your list item will get seperated to different lists

[Mr_Blackd (Luca)]

I do something like this in order to obtain in a csv table the data from the query (including the column names).

for example I call the procedure with the following sql “select * from myTable”

I have selected data with aggregated amounts, group by and having.
No issue for me. The procedure works as I needed it to.

hope it helps …

[Rogerio_Rios (Professional Support)]

What a coincidence this signature of yours about marking the answer that helped. This week I participated in 4 or 5 aids in which those who were helped did not mark the solution or not show the solution. I was going to open a topic on this subject: Who likes to be helped, is helping others?

[Rogerio_Rios (Professional Support)]

@Zia_Choudhary , I wasn’t talking about you.
Look at my history from that last week.
And you will see what the posts are.

[Zia_Choudhary (Zia Ur Rahman)]

@Rogerio_Rios ooh okey i checked … But i think it’s my right too to mark it as a solution as so that everyone seeing the thread can get the real solution easily that’s why i marked …
Btw thanku