Remove - in expression

[#1]

Hi

The following is from a hierarchy.  I have added a drop list object to my app and have created concatenate expression on the LocalServiceLine and Specialty field.  However, I do not want to include any specialty with '-'.  How can i do this.

[tresesco]

Try like:

if(Len(Trim(Specialty))>0, LocalServiceLine & ': ' & Specialty)

[#3]

unfortunately that then returns 0 and 1 in the display.

[tresesco]

Could you share a qvw with your sample data?

[umerikhlas]

Modify your expression in listbox expression as follows:

• If Specialty having null values then this:

          =if(not isnull(Specialty), LocalServiceLine & ': ' & Specialty)

• If Specialty having values equal to '-' (dashes) then this:

          =if(Specialty <> '-', LocalServiceLine & ': ' & Specialty)

Hope this will help you.

Regards,

UI

[#6]

thanks UI that has worked.