Administrator Guide

724 | Reference Dell Networking W-ClearPass Guest 6.6 | User Guide
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.
Option Description
$value
The value to be searched for
$table
A 2D array of data to search; for example, a data table returned by NwaCsvCache()
or NwaParseCsv()
$column_index
The desired index of the data
$range_lookup
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
value_column
Specifies the column index in the table that contains the values; the default is 0; in
other words, the first column.
$cmp_fn
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.
Table 329: NwaVLookup Options
Be aware of the following differences from Excel VLOOKUP:
l Column indexes are 0-based.
l Column indexes can also be strings.
See "NwaParseCsv" on page 722 and "NwaCsvCache" on page 720.
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.
Field, Form, and View Reference
This section describes the following:
l "GuestManager Standard Fields" on page 725
l "Hotspot Standard Fields" on page 733
l "SMS Services Standard Fields" on page 734
l "SMTP Services Standard Fields" on page 734
l "Format Picture String Symbols" on page 736
l "Form Field Validation Functions" on page 737
l "Form Field Conversion Functions" on page 744