I’m trying to select only rows that starts with two dates and six consecutive number, I tested a regex in regex101: build, test, and debug regex and it works perfectly but not in KNIME row filter node. I tried several solutions, i.e double backslash but didn’t work. ¿What can I do?
I give an example in the attached flow (produce an empty data table) regex_dates_numbers.knwf (19.4 KB)
Thanks for posting, and welcome to the KNIME community.
Regex is always a bit painful , here the main issue is that you must match the entire cell to filter it.
Below you can find the example that I have used to filter and create your desired outcome: