ilike

ilike(X, pattern)

Check whether each element in X fits a specific pattern. The comparison is case insensitive.

The wildcard charater % indicates 0 or more characters.

X is a scalar/vector/matrix.

pattern is a string and is usually used with wildcard character %.

Returns a Boolean scalar, vector or matrix.

ilike(`ABCDEFG, `de);
// output: 0

ilike(`ABCDEFG, "%de%");
// output: 1

a=`IBM`ibm`MSFT`Goog`YHOO`ORCL;
a ilike  "%OO%";
// output: [0,0,0,1,1,0]

a[a ilike  "%OO%"];
// output: ["Goog","YHOO"]

Related function: like