The VALUE function returns the Value from a specified member of a Name/Value set.
#VALUE(set[, index] )
Arguments:
- set: The set.
- index: The index (one-based) of the member to return the Value of. If negative, the index is from the end of the set.
Returns:
- The Value of the member of the set
Example:
WHERE ebay.active LIMIT 1
SET $mySet TO #SET()
ADD 'Name1', 'Value 1' TO $mySet
ADD 'Name2', 'Value 2' TO $mySet
ADD 'Name2', 'Value 3' TO $mySet
ADD 'Name2', 'Value 4' TO $mySet
ADD 'Name3', 'Value 5' TO $mySet
ADD 'Name4', 'Value 6' TO $mySet
EVAL #VALUE($mySet)
EVAL #VALUE($mySet, 2)
EVAL #VALUE($mySet, -2)
#VALUE($mySet)
- Value 1
#VALUE($mySet, 2)
- Value 2
#VALUE($mySet, -2)
- Value 5