Filter Function

Abs Function,Array Function,Asc Function,Atn Function,CBool Function,CByte Function,CCur Function,CDate Function,CDbl Function,Chr Function,CInt Function,CLng Function,Cos Function,CreateObject Function,CSng Function,CStr Function,Date Function,DateAdd Function,DateDiff Function,DatePart Function,DateSerial Function,DateValue Function,Day Function,Eval Function,Exp Function,Filter Function,Fix Function,FormatCurrency Function,FormatDateTime Function,FormatNumber Function,FormatPercent Function,GetLocale Function,GetObject Function,GetRef Function,Hex Function,Hour Function,InputBox Function,InStr Function,InStrRev Function,Int Function,IsArray Function,IsDate Function,IsEmpty Function,IsNull Function,IsNumeric Function,IsObject Function,Join Function,LBound Function,LCase Function,Left Function,Len Function,LoadPicture Function,Log Function,LTrim Function,Mid Function,Minute Function,Month Function,MonthName Function,MsgBox Function,Now Function,Oct Function,Replace Function,RGB Function,Right Function,Rnd Function,Round Function,RTrim Function,ScriptEngine Function,ScriptEngineBuildVersion Function,ScriptEngineMajorVersion Function,ScriptEngineMinorVersion Function,Second Function,Sgn Function,Sin Function,Space Function,Split Function,Sqr Function,StrComp Function,String Function,StrReverse Function,Tan Function,Time Function,Timer Function,TimeSerial Function,TimeValue Function,Trim Function,TypeName Function,UBound Function,UCase Function,VarType Function,Weekday Function,WeekdayName Function,Year Function Home home | Other Resources other resources | Advertise with us advertise | Link to us link to us | Contact us contact | Bookmark Us!
Google
 
Constants Errors Events Functions Keywords Methods Miscellaneous Objects Operators Properties Statements File System Object
Where can I find good Windows Web Hosting to host my VBScript Site?
You can find good Windows Hosting which support VBScript, ASP, ASP.Net,VisualStudio.Net and MSSQL at a very reasonable low monthly fee at EasyCGI.com and DiscountASP.Net
  Home > Functions > Filter Function
  • Abs Function
  • Array Function
  • Asc Function
  • Atn Function
  • CBool Function
  • CByte Function
  • CCur Function
  • CDate Function
  • CDbl Function
  • Chr Function
  • CInt Function
  • CLng Function
  • Cos Function
  • CreateObject Function
  • CSng Function
  • CStr Function
  • Date Function
  • DateAdd Function
  • DateDiff Function
  • DatePart Function
  • DateSerial Function
  • DateValue Function
  • Day Function
  • Eval Function
  • Exp Function
  • Filter Function
  • Fix Function
  • FormatCurrency Function
  • FormatDateTime Function
  • FormatNumber Function
  • FormatPercent Function
  • GetLocale Function
  • GetObject Function
  • GetRef Function
  • Hex Function
  • Hour Function
  • InputBox Function
  • InStr Function
  • InStrRev Function
  • Int Function
  • IsArray Function
  • IsDate Function
  • IsEmpty Function
  • IsNull Function
  • IsNumeric Function
  • IsObject Function
  • Join Function
  • LBound Function
  • LCase Function
  • Left Function
  • Len Function
  • LoadPicture Function
  • Log Function
  • LTrim Function
  • Mid Function
  • Minute Function
  • Month Function
  • MonthName Function
  • MsgBox Function
  • Now Function
  • Oct Function
  • Replace Function
  • RGB Function
  • Right Function
  • Rnd Function
  • Round Function
  • RTrim Function
  • ScriptEngine Function
  • ScriptEngineBuildVersion Function
  • ScriptEngineMajorVersion Function
  • ScriptEngineMinorVersion Function
  • Second Function
  • Sgn Function
  • Sin Function
  • Space Function
  • Split Function
  • Sqr Function
  • StrComp Function
  • String Function
  • StrReverse Function
  • Tan Function
  • Time Function
  • Timer Function
  • TimeSerial Function
  • TimeValue Function
  • Trim Function
  • TypeName Function
  • UBound Function
  • UCase Function
  • VarType Function
  • Weekday Function
  • WeekdayName Function
  • Year Function

    • Filter Function

    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:

    ConstantValueDescription
    vbBinaryCompare0Perform a binary comparison.
    vbTextCompare1Perform a textual comparison.

    Remarks

    If no matches of Value are found within InputStrings, Filter returns an empty array. An error occurs if InputStrings is Null or is not a one-dimensional array.

    The array returned by the Filter function contains only enough elements to contain the number of matched items.

    The following example uses the Filter function to return the array containing the search criteria "Mon": 

    Dim MyIndex
Dim MyArray (3)
MyArray(0) = "Sunday"
MyArray(1) = "Monday"
MyArray(2) = "Tuesday"
MyIndex = Filter(MyArray, "Mon") ' MyIndex(0) contains "Monday".

    Constants  |   Errors  |   Events  |   Functions  |   Keywords  |   Methods  |   Miscellaneous  |   Objects  |   Operators  |   Properties  |   Statements  |   FileSystem Objects
    VBScriptOnline.com - Abs Function,Array Function,Asc Function,Atn Function,CBool Function,CByte Function,CCur Function,CDate Function,CDbl Function,Chr Function,CInt Function,CLng Function,Cos Function,CreateObject Function,CSng Function,CStr Function,Date Function,DateAdd Function,DateDiff Function,DatePart Function,DateSerial Function,DateValue Function,Day Function,Eval Function,Exp Function,Filter Function,Fix Function,FormatCurrency Function,FormatDateTime Function,FormatNumber Function,FormatPercent Function,GetLocale Function,GetObject Function,GetRef Function,Hex Function,Hour Function,InputBox Function,InStr Function,InStrRev Function,Int Function,IsArray Function,IsDate Function,IsEmpty Function,IsNull Function,IsNumeric Function,IsObject Function,Join Function,LBound Function,LCase Function,Left Function,Len Function,LoadPicture Function,Log Function,LTrim Function,Mid Function,Minute Function,Month Function,MonthName Function,MsgBox Function,Now Function,Oct Function,Replace Function,RGB Function,Right Function,Rnd Function,Round Function,RTrim Function,ScriptEngine Function,ScriptEngineBuildVersion Function,ScriptEngineMajorVersion Function,ScriptEngineMinorVersion Function,Second Function,Sgn Function,Sin Function,Space Function,Split Function,Sqr Function,StrComp Function,String Function,StrReverse Function,Tan Function,Time Function,Timer Function,TimeSerial Function,TimeValue Function,Trim Function,TypeName Function,UBound Function,UCase Function,VarType Function,Weekday Function,WeekdayName Function,Year Function