Work with Ø in rule-based row filter

[AndreP]

Hi,

I’m happy to be a part of this community.

And of course. I have a short Question.

How can I use the special character Ø (ALT+0126) in the node “Rule-based Row Filter”.

Example:
$column1$ LIKE “1 Ø” => TRUE

I don’t get results.

Thank you very much in advance.

BR

Andre

[aworker]

Hi @AndreP and welcome to the KNIME forum.

Just a quick reply to your question. I tried your example and it works “as it is” in my case. Could you please give a couple of examples of the content in $column 1$ and the expected results for these values after “Rule-base Row filter” ?

Thanks & regards,

Ael

[takbb]

I tried it too @AndreP , (although I found I needed to use alt-0 21 6
and as with @aworker, it worked for me too.

Another thought if the alt numbers are really not working, is that it ought to work with copy-and-paste too. That wouldn’t be ideal, so hopefully the alt combinations should work for you. Let us know!

[AndreP]

@takbb Yes, I typed to fast. ALT+0216 is right. I tried it with C&P and type it directly.

@aworker

Example:

Column1
Handlebar 31,1 Ø red
Riser Bar Ø 31.5 blue
Handlebar 31,5 black
Bar 31,1cm yellow
Dropbar Ø white
Riser Ø 35,4 grey

Now I want to have a list with all values with “1 Ø” and and “Ø 3” inside.
So in my example in want to include row 1,2 and 6 and exclude 3, 4 and 5.

Edit: and yes, I used the stars before and after the quotes.

[aworker]

I see @AndreP. The problem comes from the syntax of the instruction

$column1$ LIKE “*1 Ø*” => TRUE

I believe it should be in your case:

($column1$ LIKE “*1 Ø*”) OR ($column1$ LIKE “*Ø 3*”) => TRUE
TRUE => FALSE

Parenthesis should not be needed but I’m adding them for extra clarity

Hope this helps.

Best,

Ael

Edit: I had the same problem with the forum editor. I used the stars before and after the ‘1 Ø’ but for them to appear, you need to use the editor menu option </> before and after every star

[AndreP]

Ouh Thanks! Thats helps to loose my node in my head.
And now I got my mistake!

I used one step before LOWER to prework my values… and the LOWER-Version of Ø is ø (ALT + 0248).
i didn’t think that a lower version existed.

Have a nice weekend!

[aworker]

Thanks for the feedback and good to know you got it eventually right !

Nice weekend to you @AndreP and @takbb too !

Best

Ael

[takbb]

Thanks @aworker. You too… Same time again next week