Contents - Index


NLOOKUPROWS

 

NLOOKUPROWS takes one argument which must be either a string constant or a string variable.  The string contains the name of a Lookup table (as in appears on a tab in the Lookup Table Window) or the name of a Lookup file stored on disk.   The function returns the number of rows in the specified table.  If the specified table does not exist, the function call will result in an error message.  This function is particularly useful when a Lookup file is read using the $OpenLookup directive and the number of rows is not known apriori.

 

Example:  

N=NLOOKUPROWS('LOOKUP 1') "number of rows in the Lookup Table named 'Lookup 1'"

 

 

See also: NFileRows

Lookup Window

Lookup File Formats

Mathematical Functions