Seperating list values from a string

[abeyphilip]

Hi,

I have column in an excel, with values like

list value5

list value1, list value2, list value3

Is there any way using list box expression, the second line item above can be shown as sepererate list values in a list box?

as:

List

list value5

list value1

list value2

list value3

Thanks,

Abey

[Gysbert_Wassenaar · Accepted solution]

Use the subfield function

load *, subfield(list,',') as listitem from ...etc

You may want to use trim too to get rid of extra spaces: trim(subfield(list,','))

[abeyphilip]

Hi Gysbert,

Perfect. Thanks a lot!!!