28 th Jun 2022 21:15:30
Hai Friend , Sign In
Chennai City
G. K.
Tamil Nadu Government Holiday List 2018 in English and Tamil   *   Trichy: Wanted - PHP, MySql Programmers. Contact trichy people only 84894 28 444.   *   Indian Railways New Train Number List [Search / Enquiry / Locator / Finder]   *   பன்றிக் காய்ச்சல் பற்றி அறிந்து கொள்ளுங்கள் (Swine Flu H1N1)
See Also
Replace Function Replace Function
Array Functions Array Functions
Visual Basic Functions Visual Basic Functions
Visual Basic Home Visual Basic Home
Description  Syntax  Return Datatype  Example  Migration

Filter Function - Visual Basic 6.0 (VB 6.0)

Returns a zero-based array containing subset of a string array based on a specified filter criteria.
Filter(sourcearray, match[, include[, compare]])
Parameter Description
sourcearray Required. One-dimensional array of strings to be searched.
match Required. String to search for.
include Optional. Default True. Boolean value indicating whether to return substrings that include or exclude match.
compare Optional. Numeric value indicating the kind of string comparison to use.

InStr Function's compare argument:
Constants Value Description
vbUseCompareOption -1 Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare 0 Default. Perform a binary comparison.
vbTextCompare 1 Perform a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.

Return Data type:
See Examples for Filter Function in Visual Basic

Migration from Visual Basic 6.0 (VB 6.0) to
  Filter Function in VB Script (VBS)
  Filter Function in JScript (JS)
  Filter Function in ASP (Active Server Page)
  Filter Function in PHP Script
  Filter Function in MS-Access
  Filter Function in MS SQL Server
  Filter Function in Oracle
  Filter Function in C Language
  Filter Function in C++ Language
  Filter Function in Foxpro
  Filter Function in Fortran
  Filter Function in MS Excel Sheet
Go to top

© 2021 Chennaiiq.com. All Rights Reserved.