Manipulate string for ComboBox

HCL Domino Domino Forum
1

Morning all,

I have a DBlookup I perform and then loop through the elements in formula.

I am trying to exclude items that contain a certain string.

So I have that working just fine.

The issue is, What I end up with in My Dropdown List is 1 entry that is all of the returned data in one big string.

That is what I am doing in the formula below. How do I break up the entries so that they display each entry seperately on a new line. I tried @newline in the formula to no avail.

Shawn

@For(

N := 1;

N <= @Elements(tempCompanyList);

N := N + 1;

@If(!@Contains(tempCompanyList[N]; “ABC”); companyList := companyList + tempCompanyList[N]; “”));

companyList

2

Subject: Manipulate string for ComboBox

You need to use a colon instead of the plus sign

companyList := companyList : tempCompanyList[N];

You may find the first entry is an empty string. If it is get rid of it using @Trim(companyList)