Filterbeforereadingbasicsyntaxcrystalsyntax

Filters an array of strings for a specified string.

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

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].

A string

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"

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".

Help - Filter