VA FileMan V. 22.0 Getting Started HTML Manual Banner

 

Contents: Main Chapter See Also: Getting Started Manual Programmer Manual

VA FileMan Functions

nTH

Format: The syntax of this function is different because the function's name is defined by the user. The name is a number followed by an ordinal number suffix.
  1. nTH(fname)

  2. nTH(fname:field)
Parameters:
  1. In the first format, fname is the name of a file or of a Multiple in your current file.

  2. In the second format:

    • fname is the name of your current file or Multiple.

    • field is the name of a field (or a field number preceded by #) in fname.
Use: This function returns the nth entry in a file or in a Multiple identified by fname. If the second format is used, the value of the specified field associated with the nth entry in fname is returned. The nth entry is determined by the internal entry number; the function does not analyze the values of the entries. When used with the second format, the nth subentry with a non-null value is returned.
Examples:

2ND(DIAGNOSIS)=> Angina Pectoris [the second entry in the DIAGNOSIS Multiple]

10TH(ADMISSION:ADMISSION DATE)=> JAN 2,1990 [ADMISSION DATE associated with the tenth ADMISSION]

 

Reviewed/Updated: March 4, 2007