Differences Between Two Lists

Mindwatering Incorporated

Author: Tripp W Black

Created: 06/17/2009 at 02:46 PM

 

Category:
Notes Developer Tips
Formulas

OldList - old list of members
NewList - updated list of members

Get the new members added only:
tmp1:=@Unique(NewList : OldList );
@Trim(@Replace(tmp1; OldList ; ""))

Get the members removed:
tmp1:=@Unique(NewList: OldList );
@Trim(@Replace(tmp1; NewList ; ""))

__________________

LotusScript Equivalent:
e.g.
addLst = Fulltrim(ArrayReplace(comboLst, oldLst, "")
Call doc.ReplaceItemValue("F_Adds", addLst)

previous page