wildcard

[n1ef5ng1]

I have a listbox that contains 200+ fields. I would like to filter on fields that I need.

However, those fields that i would want to filter in listbox have a comma in between.

if(Place = 'Semarang,Java','indonesia;')

becasue of that comma, it does not read that particular field, think is because if statement detect comma as next command.

I tried * such as if(place = 'semarang*','indonesia), it doesn read too.

Any advice

[Gysbert_Wassenaar]

If you want filter the values in the listbox that contain a comma you can enter *,* as search string.

[CELAMBARASAN]

I dont think it will do where your using this expression? chart, script...?

if it is a problem then check with this

As gwassenaar said you want to filter the values with comma then go with wildmatch(fieldname, '*,*')

or you need to filter some values(hard coded) then

if(Place = 'Semarang' & Chr(44) & 'Java','indonesia;')

Hope that helps