Kontrola pole – Visual Basic – Fórum – Programujte.com

Zdravím, potřebuji vědět zda ve visual basicu je podobná funkce jako v php - in_array. děkuji

možná funkce Filter

Dim Tab(100) as string, Vysledek as Variant
Vysledek = Filter(Tab, "AS")

v uvedeném příkladu funkce Filter projde pole Tab a do proměnné Vysledek (musí být Variant) vrátí pole pouze sprvky, které obsahují hledaný řetězec

tolik citace ze známé knihy, nikdy jsem to nezkoušel. Doplněn anglický help:

Filter Function

Description

Returns a zero-based array containing subset of a string array based on a specified filter criteria.

Syntax

Filter(InputStrings, Value[, Include[, Compare]])

The Filter function syntax has these parts:

Part Description

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
vbUseCompareOption –1 Performs a comparison using the setting of the Option Compare statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a comparison based on information in your database.

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.

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.