Rule Based Row Filter - Capitalized Text

[rparr009]

All,

I have a rule based row filter in which I am trying to filter based on text ex: “john”. However, when the text in excel doc is formated as “JOHN” I am not picking it up.

I would rather not use another OR function to fix this. Is there another way to have to node not consider capital letters?

Thanks,

RJ

[izaychik63]

KNIME is case sensitive. If you want to preserve original values, duplicate them and convert to the same case.

[bruno29a]

Hi @rparr009 , as @izaychik63 said, Knime is case sensitive.

I am guessing, in your Rule-based Row Filter, you probably have something like this:
$column1$ = "john" => TRUE

If you don’t want case sensitivity to affect this rule, you just need to make sure that your column data is all in lower or upper case beforehand, and then apply the rule accordingly. In my example, I will convert the data to lower case, and you can do this via the String Manipulation node with the lowerCase() function, like this:

You can either replace the original column with the manipulation, or decide to add it as a new column.

You can then apply your rule on the lower cased column.

Here’s a sample workflow:

Input data:

Filtered data on “john”:

And here’s the workflow: rule-based row filter case insensitive.knwf (8.1 KB)

[gonhaddock]

hi @rparr009 ,

A single node solution may be to use Regex in a standard ‘Row Filter’ node:

(?i)(john)

Regards