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”.
$column1$ LIKE “1 Ø” => TRUE
I don’t get results.
Thank you very much in advance.
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,
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!
@takbb Yes, I typed to fast. ALT+0216 is right. I tried it with C&P and type it directly.
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.
I see @AndreP. The problem comes from the syntax of the instruction
$column1$ LIKE “
*” => TRUE
I believe it should be in your case:
($column1$ LIKE “
*”) OR ($column1$ LIKE “
*”) => TRUE
TRUE => FALSE
Parenthesis should not be needed but I’m adding them for extra clarity
Hope this helps.
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
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!
Thanks for the feedback and good to know you got it eventually right !
Nice weekend to you @AndreP and @takbb too !
Thanks @aworker. You too… Same time again next week
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.