List box string help???

[amit_saini]

Hi Folks,

Looking for help below:

I'm having list box like below as calculates expression

=if (not isnull(PLANT),PLANT & ' - ' & NAME1)

Here PLANT = Plant numbers and NAME1 = Plant Description.

How to show values in the list box starting with 5* along withdescription?????

Thanks,

AS

[jonathandienst · Accepted solution]

Hi

=if(Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)

This will also exclude nulls

HTH

Jonathan

[amit_saini]

Jonathan,

Thank u for your help.

Just want to ask you one more thing , Suppose I do have some plant number(i.e PLANT) not having description (i.e. NAME1) , so is there any way to show only  those Plant numbers having description in list box????

Thanks,

AS

[tresesco]

One more check would help there. May be like:

=if(Len(Trim(NAME1))>0 and Left(PLANT, 1) = '5', PLANT & ' - ' & NAME1)