IndexValue( sourcestring , delimiterstring, indexnumber)
| Argument | Description |
|---|---|
| sourcestring | The list of values |
| delimiterstring | The string that seperates the values in the sourcestring |
| indexnumber | The numeric index of the values to retrieve |
data type: String
Example 1
Section titled “Example 1”IndexValue('a#b#c#d', '#' , 3)
This expression returns c
Example 2
Section titled “Example 2”IndexValue('a#b#c#d', '#' , 0)
This expression returns “empty string”
Example 3
Section titled “Example 3”IndexValue('aXXbXXcXXdXXe', 'XX' , -1)
This expressions returns e
Example 4
Section titled “Example 4”IndexValue('aXXbXXcXXdXXe', 'XX' , -2)
This expressions returns d