icase not in
The icase not in
match filter returns rows that do not contain a match of one or more specified values, regardless of the capitalization of the values.
Syntax
columnName icase not in valueList
columnName
- the column the filter will search for non-matching values.valueList
- the set of values to remove. This supports:- a comma-separated list of values:
A icase not in X, Y, Z
. The filter will returntrue
for all rows where the value in columnA
is not equal toX
,Y
, andZ
. - a java array:
A icase not in X
. The filter will returntrue
for all rows whereA
is not equal to every element of the java arrayX
. - a
java.util.Collection
:A icase not in X
. The filter will returntrue
for all rows whereA
is not equal to every element of the collectionX
.
- a comma-separated list of values:
- all other types:
A icase not in X
. The filter will returntrue
for all rows whereA
is not equal toX
.
Examples
The following example returns rows where Color
is not in the comma-separated list of values. Capitalization is ignored.
source = newTable(
stringCol("Letter", "A", "C", "F", "B", "E", "D", "A"),
intCol("Number", NULL_INT, 2, 1, NULL_INT, 4, 5, 3),
stringCol("Color", "red", "blue", "orange", "purple", "yellow", "pink", "blue"),
intCol("Code", 12, 13, 11, NULL_INT, 16, 14, NULL_INT),
)
result = source.where("Color icase not in `Blue`, `Orange`")
- source
- result
The following example returns rows where Color
is not blue
or Letter
is not a
. Capitalization is ignored.
import io.deephaven.api.filter.FilterOr
import io.deephaven.api.filter.Filter
source = newTable(
stringCol("Letter", "A", "C", "F", "B", "E", "D", "A"),
intCol("Number", NULL_INT, 2, 1, NULL_INT, 4, 5, 3),
stringCol("Color", "red", "blue", "orange", "purple", "yellow", "pink", "blue"),
intCol("Code", 12, 13, 11, NULL_INT, 16, 14, NULL_INT),
)
result = source.where(FilterOr.of(Filter.from("Color icase not in `Blue`", "Letter icase not in `a`")))
- source
- result
The following example returns rows where Color
is not in a collection of values.
myList = ["Pink", "purple", "BLUE"]
source = newTable(
stringCol("Letter", "A", "C", "F", "B", "E", "D", "A"),
intCol("Number", NULL_INT, 2, 1, NULL_INT, 4, 5, 3),
stringCol("Color", "red", "blue", "orange", "purple", "yellow", "pink", "blue"),
intCol("Code", 12, 13, 11, NULL_INT, 16, 14, NULL_INT),
)
result = source.where("Color icase not in myList")
- source
- result