INDEX function
Returns the substring at the zero-based location index in the list delimited by delimiter. Or, it returns -1 if not found.
Syntax
|
INDEX(index,"list"[,[delimiter][,[errorvalue]]]) | |
|
index |
The location that you want to find. |
|
list |
The list in which you want to search. |
|
delimiter |
The string to use as a delimiter within list. A delimiter string can be more than one character in length and include multibyte characters. The default is a semicolon. |
|
errorvalue |
Optional. A user-specified value to return if the index is out of range. The default is an empty string. |
Remarks
If the list begins or ends with a delimiter, a null string is assumed to exist before or after the list. Consecutive delimiters imply a null string in between.
If the index is out of range, Microsoft Visio returns an empty string or the optional token provided as the errorvalue argument.
Example 1
INDEX(3,"cat;rat;;goat")
Returns "goat".
Example 2
INDEX(54,";1;2;3;",,"ERROR")
Returns "ERROR."