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 omitted, a binary comparison is performed. |
vbBinaryCompare - perform a binary comparison
vbTextCompare (default) - perform a textual comparison
The array returned by the function contains only enough elements to contain the number of matched items.
nArray(0) = "Sunday"
nArray(1) = "Monday"
nArray(2) = "Tuesday"
nIndex = Filter(MyArray, "Mon") 'MyIndex(0) contains "Monday"