Subfield() function problem

[#1]

Hi,

I have a list box containing values with comma(s) and without comma. I would like to show all distinct values in that list box.

When I used subfield() function, it shows value which is not there in the available choices. Looks like something weird happening. Please see a snap shot below:

Picture on the left is what I have, picture on the right is the outcome of the following expression.

=if(Index(UseCase,',') <> 0,Trim(SubField(UseCase,',')),Trim(UseCase))

I would like to see the following result:

Data Center Consolidation

Disaster Recovery

Partial Environment Consolidation

Any help is appreciated.

Thank you,

Parth

[Clever_Anjos · Accepted solution]

You should create a field at script level and use it into your listbox

[MK_QSL]

Use

SubField(UseCase,',') as UseCase

at script level.

[#4]

Thank you. It worked. Have a good one.

Regards,

Parth Shah.

[#5]

Thank you. It worked. Have a good one.

Regards,

Parth Shah.