I tried combining the two fields and using @Unique to eliminate duplicate values. However, because @Unique is case sensitive and the two sources often listed the same values in different case, this didn't work. Another problem that I encountered is that it's easy for me to make mistakes when writing loop functions in Formula language.
The LotusScript equivalent for @Unique -- ArrayUnique -- can be case insensitive. I needed a formula that would do this for a computed field on a Lotus Notes form.
The function loops through the elements of one list, comparing them to the elements in the second, using the @Compare function, with the "CaseInsensitive" switch.
Do you have comments on this tip? Let us know.
This tip was submitted to the SearchDomino.com tip library by member Patrick Kenney. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes/Domino technical tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.