{{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".
SEP IT AG
sep.ch verwendet Cookies und ähnliche Technologien, um das Nutzererlebnis auf unserer Webseite zu verbessern und unseren Datenverkehr zu analysieren. Mehr Informationen in unserer Datenschutzerklärung


Help - Filter