How do I remove blank values from SearchBox

[#1]

Hi,

I have one Search Box which contains my values let's say A, B, C plus another one blank line. Is it possible to show only A,B,C and exclude the blank one?

I also have to mention that I can't exclude this from the load script as I need the values to sum up including this blank line.

Thanks!

[Oleg_Troyansky]

Adina,

you must be referring to the List Box, not to the Search Object, right? I can suggest 3 choices:

1. In the load script, replace empty strings with a text such as "Missing", or "N/A"... This way, your List Box will show 3 valid values and one value that is "missing".

2. In the script, replace empty strings with nulls. Nulls will be excluded from the List Box, while the corresponding numbers still remain in the dataset.

3. In the list box, use a calculated expression, something like this:

IF(len(trim(Field))>0, Field, null())

This might be a bit heavier on the performance side...

cheers,

Oleg