how to segregate all the data in list box if I have a data in between comma is present.

[shivam0703]

I want all the data of the list box in another list box but data should be only 1 in each line currently my data is separated by comma in list of  column(list box) .

check screenshot.

eg: current data I have in list box is:  leads detail, sales, crm name, date

                                                                           crm name

                                                                             dealer, region

but I need data(distinct ) in list box as : 

leads detail

sales

crm name

date

  dealer

region

[Saravanan_Desingh]

One solution is.

tab1:
LOAD *, LTrim(SubField(F1,',')) As F2
;
LOAD * INLINE [
    F1
    "leads detail, sales, crm name, date"
    crm name
    "dealer, region"
];

[Saravanan_Desingh · Accepted solution]