a = Filter(InputStrings, Value[, Include[, Compare]])| InputStrings | (String) 1-dimensional array of strings to be searched. |
|---|---|
| Value | (String) String to search for |
| Include | [optional] (Boolean) Logical value indicating whether to return substrings that include or exclude Value true (default) - function returns the subset of the array that contains Value as a substring false - function returns the subset of the array that does not contain Value as a substring |
| Compare | [optional] (Integer) Numeric value indicating the kind of string comparison to use. If not set, then a binary comparison is performed. vbBinaryCompare - perform a binary comparison vbTextCompare (default) - perform a textual comparison |
If no matches of Value are found within InputStrings, then the function returns an empty array.
If InputStrings is Null or is not a 1-dimensional array then error occurs.
The array returned by the function contains only enough elements to contain the number of matched items.
Dim nIndex, arr(2)
arr(0) = "Sunday"
arr(1) = "Monday"
arr(2) = "Tuesday"
nIndex = Filter(arr, "Mon") 'nIndex(0) = "Monday"