Easy Tutorial
Func Monthname Func Strreverse Vb Func Now Func Ccur Func String Func Vartype Func Right Func Oct Func Timeserial Func Log Func Cint Func Sin Func Atn Func Formatcurrency Func Getref Func Tan Func Isarray Index Func Timer Func Strcomp Func Month Func Createobject Func Isdate Func Isnumeric Vbscript Summary Func Msgbox Func Eval Func Cbyte Func Isempty Func Join Func Formatdatetime Func Isnull Vb Func Dateadd Vbscript Tutorial Func Timevalue Func Getlocale Func Sgn Func Isobject Func Hex Func Int Func Lbound Func Day Func Cdbl Func Dateserial Func Split Func Sqr Vbscript Conditionals Func Cos Func Weekday Func Hour Func Rtrim Func Abs Func Ltrim Func Scriptengine Func Clng Func Trim Func Datevalue Func Cstr Vbscript Examples Vb Func Datepart Func Len Vb Func Array Func Asc Func Space Func Instr Vbscript Ref Functions Func Weekdayname Func Getobject Vb Func Datediff Func Fix Vbscript Ref Keywords Func Inputbox Func Typename Func Mid Func Formatnumber Func Rgb Func Second Func Cbool Func Instrrev Func Year Func Cdate Func Ubound Func Setlocale Func Rnd Func Replace Func Round Vb Func Date Func Exp Func Ucase Vbscript Procedures Func Formatpercent Vbscript Howto Func Left Func Minute Func Time Func Filter Func Lcase Func Csng Func Chr Vbscript Variables Vbscript Looping Func Loadpicture
❮ Func Time Func Lcase ❯

VBScript Filter Function

The Filter function returns a zero-based array that contains a subset of a string array based on specified filter criteria.

Note: If no matching values are found for the value parameter, the Filter function returns an empty array.

Note: An error occurs if the inputstrings parameter is Null or is not a one-dimensional array.

Syntax

Parameter Description
inputstrings Required. A one-dimensional array of strings to be searched.
value Required. The string to search for.
include Optional. A Boolean value that indicates 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. The default is True.
compare Optional. Specifies the type of string comparison to use. Possible values: 0 = vbBinaryCompare - Perform a binary comparison<br>1 = vbTextCompare - Perform a text comparison

Example 1

Filter: Items containing "S":

Example output:

Example 2

Filter: Items not containing "S" (include=False):

Example output:

Example 3

Filter: Items containing "S" using text comparison (compare=1):

Example output:

❮ Func Time Func Lcase ❯