Testo
15 pts. | Jul 7 2009 10:39AM GMT
Thanks Steve, seems to be the correct method.
Not being a Lotus Notes expert, can you also suggest me how I can integrate it into the formula that I have in the design option for the “Who” column?
SentBy := @If(Principal = “”; From; Principal);
Attendees := @Trim(RequiredAttendees : OptionalAttendees);
Who := @If(DeliveredDate != “”; SentBy; @Elements(Attendees) > 0; @Subset(Attendees; 1); SendTo = “”; SentBy; @Subset(SendTo; 1));
W := @Trim(@Name([CN]; Who));
CN:=@LowerCase(W);
AllE := @Explode(W; ” “);
NbE := @Elements(@Explode(CN; ” “));
E2 := @If( NbE>1; @Subset(@Subset(AllE; NbE-1); -1); “”);
E3 := @If( NbE>2; @Subset(@Subset(AllE; NbE-2); -1); “”);
E4 := @If( NbE>3; @Subset(@Subset(AllE; NbE-3); -1); “”);
miE2 := @If(@Length(E2)=1; @True; @False);
miE3 := @If(@Length(E3)=1; @True; @False);
n2a := W;
xLn := “”;
xFn := “”;
P := @If(
NbE = 1;
@If(
@Like(Who; “%@%.%”);
CN;
@UpperCase(W)
);
Who = @UpperCase(Who);
Who;
“”
);






