VBScript Filter Function
Complete VBScript Reference
The Filter function returns a zerobased array that contains a subset of a string array based on a filter criteria.
Note: If no matches of the value parameter are found, the Filter function will return an empty array.
Note: If the parameter inputstrings is Null or is NOT a onedimensional array, an error will occur.
Syntax
Filter(inputstrings,value[,include[,compare]])
Parameter  Description 

inputstrings  Required. A onedimensional array of strings to be searched 
value  Required. The string to search for 
include  Optional. A Boolean value that indicates whether to return the substrings that include or exclude value. True returns the subset of the array that contains value as a substring. False returns the subset of the array that does not contain value as a substring. Default is True. 
compare  Optional. Specifies the string comparison to use. Can have one of the following values:

Examples
Example 1
Filter: items that contains "S"
<%
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S")
for each x in b
response.write(x & "<br />")
next
%>
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S")
for each x in b
response.write(x & "<br />")
next
%>
The output of the code above will be:
Sunday
Saturday
Saturday
Show Example »
Example 2
Filter: items that does NOT contain "S" (include=False):
<%
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S",False)
for each x in b
response.write(x & "<br />")
next
%>
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S",False)
for each x in b
response.write(x & "<br />")
next
%>
The output of the code above will be:
Monday
Tuesday
Wednesday
Thursday
Friday
Tuesday
Wednesday
Thursday
Friday
Show Example »
Example 3
Filter: items that contains "S", with a textual comparison (compare=1):
<%
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S",True,1)
for each x in b
response.write(x & "<br />")
next
%>
a=Array("Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")
b=Filter(a,"S",True,1)
for each x in b
response.write(x & "<br />")
next
%>
The output of the code above will be:
Sunday
Tuesday
Wednesday
Thursday
Saturday
Tuesday
Wednesday
Thursday
Saturday
Show Example »
Complete VBScript Reference
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]