List box task

[#1]

i want to hide a field value which are having 'a' as a first letter in name.............

For example in list box field is salesman....then i want to show without salesman names which are consist a as a first letter at script level

salesperson	sales
aravind	20%
bhanu	30%
naveen	15%
purush	15%
chaithu	20%
sai	0%

if u create  a list box with salesperson field in script level u shoud comment the name which is have starting letter a (aravind)

[swuehl · Accepted solution]

I haven't understood if you want the salesperson just to hide from the list box or you want to exclude them when reloading data:

List box: Create an expression (select <expression> from field list dop down):

=if( lower(left(salesperson,1)) <> 'a', salesperson)

In the script, you can use a where clause:

LOAD

     salesperson,

     sales,

...

FROM ...

WHERE lower(left(salesperson,1)) <> 'a';