Lotus Script Trick: Remove The Duplicate Values From a Profile field in a Profile Document

The following function removes the duplicate values from a profile field, or any multi-value field (FieldName), in a profile document or a regular notes document. Function RemoveDuplicateValue(Source As NotesUiDocument, FieldName As String) Dim Indexresult As Variant Dim UniqueArr As VariantIndexresult=Source.Document.GetItemValue(FieldName) ”Get the field values into arrayUniqueArr= Arrayunique(Indexresult,1) ”Copy array but with unique items only. Call […]

Continue Reading

MS Excel Formula Magic

Generate a list of files from the OS directory specified in a cell using MS Excel. Start with a Excel Workbook and follow these steps to create a named formula. From the Formula menu choose Define Name -> Define Name From New Name Dialog box provide formula name, say FilesList. Leave Scope to Workbook. In […]

Continue Reading