Nth position of a list

View member feedback to this tip.

It is easy to retrieve the first and last element of a list, but how do you return the nth position of a list?

The @Subset function can return the 1st position, the last position and X number of items in the list, but it can't return the nth value in the list.

The following code is an example of how to return the nth position of a text list.

First, make sure that your list actually contains at least the correct number of elements. Next, you use @Subset to return N number of elements. Finally, you grab the last element in that shortened list that corresponds to the element that you were looking for.

MEMBER FEEDBACK TO THIS TIP

I used to use this technique all the time.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT Formula View hidden fields on Lotus Notes/Domino forms Case-insensitive @Unique version combines fields on Lotus Notes forms Provide rich-text formatting via the Profile document and Formula Using Formula language code to sort Lotus Notes messages by subject How to create dynamic JavaScript in Notes Domino without formulas Formula language button manages Deny Access list searches Retrieve Lotus Notes names from a nested group using @DBLookup Create a computed Lotus Notes field to list Personal Address Book names Show multiple Lotus Notes document fields in a single view column How to send a document as a link in a Lotus Notes email Lotus Notes Domino Formula Language View hidden fields on Lotus Notes/Domino forms Case-insensitive @Unique version combines fields on Lotus Notes forms Do I use Formula or LotusScript to include a doclink to a Notes view? Top 10 Lotus Notes/Domino coding and development tips of 2008 Provide rich-text formatting via the Profile document and Formula Top 10 Formula language tips Using Formula language code to sort Lotus Notes messages by subject How to create dynamic JavaScript in Notes Domino without formulas Stop response documents from showing in a Lotus Notes form Formula language button manages Deny Access list searches

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

Then I learned about the @GetMembers function introduced in R5. It is undocumented in R5, but is supposed to be documented in ND6.

The @GetMembers function gets a member from a list. The first parameter is the list and the second is a number corresponding to the position of the list member you want to get. Beats the @Subset(@Subset(list; n);-1) function in clarity and simplicity because you don't have to do any error checking. For n = 0 the nested @Subset method generates an error for which you need to trap. The @GetMembers function, however, simply returns a null value for n <= 0. Search for @GetMembers in the "Notes/Domino 4 and 5 Forum" on the Lotus Developer Domain Web site for more information.

-- Gardner R.

Do you have comments of your own? Let us know.