position(X;L)
Returns the position of a given value in a specified list.
Syntax
position(X;L)Input
| Argument | Type | Description |
|---|---|---|
X |
any | The value to find within in the list LA column name |
| L | any | A space or comma-separated literal list of values All of the values in |
Return Value
Returns an integer value corresponding to the position of X in
L. If X is not in L, the value returned
is one plus the number of items in L.
If X is N/A, the result is N/A. However, if X is the
empty string (''), and L contains one or more empty
strings, the result is the position of the first empty string in the list.
Sample Usage
X |
L |
position(X;L) |
|---|---|---|
| 'b' | 'a' 'b' 'c' | 2 |
| 100 | 1,10,100 | 3 |
| 1.9 | 1.1 1.2 1.3 | 4 |
| NA | 2.1,21.0,1.1,11.0 | 5 |
| '' | '2.1','','1.1','' | 2 |
| '' | '2.1','21.0','1.1','11.0' | 5 |
Example
Selecting the position of the 'bar' element from the literal list of values supplied to the
position() function.
<base table="default.lonely"/> <willbe name="position_result" value="position('bar';'foo' 'bar' 'baz')"/>
Returns the following table:
