Filter
[this page | pdf]
Function Description
Returns an array of elements that contains some or all of
the elements of InputArray.
If IncludeMatches is true then elements of InputArray
are included in the output array only if the relevant element contains MatchValue.
If IncludeMatches is false then elements of InputArray are included in
the output array only if the relevant element does not contain MatchValue.
If IsCaseSensitive is true then function uses
‘binary’ comparison so differentiates between upper and lower case letters,
otherwise uses ‘text’ comparison and so does not differentiate between upper
and lower case letters.
NAVIGATION LINKS
Contents | Prev | Next
Output type / Parameter details
Output type: String()
| Parameter Name | Variable Type | Description |
| InputArray | String() | Input array of strings |
| MatchValue | String | String to test whether present in idividual elements of input array |
| IncludeMatches | Boolean | If true then include strings with a match, else include strings without a match |
| IsCaseSensitive | Boolean | Flag to indicate whether to do a case sensitive comparison |
Links to:
-
Interactively run function
-
Interactive instructions
-
Example calculation
-
Output type / Parameter details
-
Illustrative spreadsheet
-
Other String functions
-
Computation units used
Note: If you use any Nematrian web service either programmatically or interactively then you will be deemed to have agreed to the Nematrian website License Agreement