ilike
Syntax
ilike(X, pattern)
Arguments
X is a scalar/vector/matrix.
pattern is a string and is usually used with wildcard character %.
Details
Return a Boolean value scalar or vector indicating whether each element in X fits a specific pattern. The comparison is case insensitive.
The wildcard charater % indicates 0 or more characters.
Examples
$ ilike(`ABCDEFG, `de);
0
$ ilike(`ABCDEFG, "%de%");
1
$ a=`IBM`ibm`MSFT`Goog`YHOO`ORCL;
$ a ilike "%OO%";
[0,0,0,1,1,0]
$ a[a ilike "%OO%"];
["Goog","YHOO"]
Related function: like