Regex doesn't work on Row Filter

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.

Hey @isra4884 :wave:t2: ,

Thanks for posting, and welcome to the KNIME community.
Regex is always a bit painful :face_with_head_bandage:, 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:

^[0-9]{2}\/[0-9]{2}\/[0-9]{4}.[0-9]{2}\/[0-9]{2}\/[0-9]{4}.[0-9]{6}.+

May notice that this Regex is literally matching the first part of your cell: 01/06/2022 01/06/2022 853342 (spaces included)

The final “.+” regex matches the rest of the content, whatever it is.

I hope it is helpful, and don’t hesitate to post here if you have further doubts or need support.

BR

6 Likes

Thanks @diego_rod_lop it works perfectly!!!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.