{{sidenavigation.sidenavigationExpandLabel}}
{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}
{{$root.getMsg("downLoadHelpAsPdf")}} {{helpModel.downloadHelpPdfDataStatus}}

Filter

Filters an array of strings for a specified string.

Usage:

Filter( x, y )
Filter( x, y, z )
Filter( x, y, z, w )

Parameters:

x The input string array containing the strings to filter.
y The filter value.
z A flag specifying whether to include or exclude all strings in x equal to y (true includes, false excludes) [OPTIONAL, default is true].
w This decides whether to compare case-sensitive(0) or not (1) [OPTIONAL, default is 0].

Returns:

A string

Examples:

Crystal Syntax:

filter(["abc abc abc abc abc","hjjh","hjabc hj"],"abc")[1]
-> Returns "abc abc abc abc abc"
filter(["abc abc abc abc abc","hjjh","hj abc hj"],"abc",true)[1]
-> Returns "abc abc abc abc abc"

Basic Syntax:

formula = filter(Array("abc abc abc abc abc","hjjh","hjabc hj"),"abc",false)(1)
-> Returns "hjjh".
formula = filter(Array("abc abc abc abc abc","hjjh","hjabc hj"),"aBc",1)
-> Returns "abc abc abc abc abc".
i-net Clear Reports
This application uses cookies to allow login. By continuing to use this application, you agree to the use of cookies.


Help - Filter