Contents - Index


NLOOKUPCOLUMNS

 

NLOOKUPCOLUMNS 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 columns 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 Look file is read with the $OpenLookup directive and the number of columns is not known apriori.

 

Example:  

N=NLOOKUPCOLUMNS('LOOKUP 1') "number of columns in the Lookup Table named 'Lookup 1'"

 

 

See also: Lookup Window

Lookup File Formats

NLOOKUPROWS

Mathematical Functions