Dell PowerConnect W Clearpass 100 Software 3.7 Deployment Guide - Page 383

NwaVLookup NwaVLookup($value, $table, $column_index, $range_lookup = true, $value_column = 0, $cmp_fn = null) Table lookup function, similar to the Excel function VLOOKUP(). This function searches for a value in the first column of a table and returns a value in the same row from another column in the table. This function supports the values described in the table below. Table 36 NwaVLookup Options Option Description $value $table $column_index $range_lookup value_column $cmp_fn The value to look for A 2D array of data to search; for example, a data table returned by NwaCsvCache() or NwaParseCsv() The desired index of the data Specifies whether to find an exact or approximate match. If true (default), assumes the table is sorted and returns either an exact match, or the match from the row with the next largest value that is less than $value. If false, only an exact match is returned; NULL is returned on no match Specifies the column index in the table that contains the values; the default is 0; in other words, the first column. Specifies a comparison function to use for values; if null, the default is used (simple equality operator ==, or the == and > operators if using binary search). The comparison function should take 2 arguments and return a value < 0, == 0, > 0 depending on the sort ordering of the arguments. Note the following differences from Excel VLOOKUP:  Column indexes are 0-based.  Column indexes can also be strings. See "NwaParseCsv" and "NwaCsvCache". NwaWordsPassword NwaWordsPassword($len) Generates a password consisting of two randomly-chosen words, separated by a small number (1 or 2 digits); that is, in the format word1XXword2. The random words selected will have a maximum length of $len characters, and a minimum length of 3 characters. $len must be at least 3. Amigopod 3.7 | Deployment Guide Reference | 383