Returns a zero-based array containing a subset of a string array based on a specified filter criteria.
|
---|
Filter(InputStrings, Value[, Include[, Compare]]) |
Arguments
- InputStrings
Required. One-dimensional array of strings to be searched.
- Value
Required. String to search for.
- Include
Optional. Boolean value indicating whether to return substrings that include or exclude Value. If Include is True, Filter returns the subset of the array that contains Value as a substring. If Include is False, Filter returns the subset of the array that does not contain Value as a substring.
- Compare
Optional. Numeric value indicating the kind of string comparison to use. See Settings section for values.
Settings
The Compare argument can have the following values:
Constant
|
Value
|
Description
|
---|
vbBinaryCompare | 0 | Perform a binary comparison. |
vbTextCompare | 1 | Perform a textual comparison. |
Remarks
Requirements
See Also