Categorize colums

HCL Domino Domino Forum
1

Question is, how do you make the the 2nd column get the information (Categorize ) from the 1st Column and then put it into 2nd Column as it is listed below. Part of my code to list the names by their first letter in the last name is below. That works Ok but I can not get it categoize into smaller groups. This is a list of names in a database. Listed by last name firstHave not had much programing doing this. This is in Lotus Script

Any idea

thanks in advance

@If(individual < “B”;“A”;individual<“C”;“B”;individual<“D”;“C”;individual<“E”;“D”;individual<“F”;“E”;

this how i would like the names listed

1st Column 2nd Column

A

                 AA

                 AB

B

                 BA

                 BB

C

D

E

and so one

2

Subject: This is not in LotusScript

Views selections and columns in view use @Functions formula (and what you write down is one)

I would try the following:

first categorized column (based on the expectation that the field individual is the lastname)

@Left (individual, 1)

second categorized column (based on the expectation that the field individual is the lastname)

@Left (individual, 2)

Does this do the trick?

3

Subject: Categorize colums

Yes that works perfect… Thank you very much

4

Subject: your welcome - you might Want to add @Uppercase(), too