Null values in List Box

[Anonymous]

Hello All.

I am having some null values in my list box.

Could some body help to remove those null values from list box?

Regards,

Balraj Ahlawat

[hic · Accepted solution]

NULL values are never shown in list boxes. Instead, what you probably have is empty strings, or strings with blanks. I would convert these to NULLs in the script by using

     If(Len(Trim(MyField))>0,MyField) as MyField

Then they will not show up in the list box.

HIC

[tresesco]

Try expression, like: If(len(Trim(YourField))>0, YourField)

[SunilChauhan]

if( fieldname<>' ',Fieldname)

if(len(fieldname)>0,Fieldname) /// as henric suggeted

if(fieldname=null(),fieldName)

or if there is some null characters like .,-

then

you can use

if(fieldname<>'.',fieldname)

if(fieldname<>'-',fieldname)

hope one of them work for you

[Anonymous]

Agreed Henric,

Its not null values, It is empty strings.

Let me try out with this expression.

Regards,

Balraj Ahlawat

[Anonymous]

Thanks.

Its done.

Regards,

Balraj Ahlawat