Hi, I was trying to find dates of format “03/03/2023” in a table and I used the below regex match as in the screenshot. [Screenshot 2023-07-23 at 9.52.14 AM] However, this regex match gives me false results. ( screenshot below) [Screenshot 2023-07-23 at 9.48.20 AM] But, when I use the same regex under a Python script - I get the right results. ( screenshot below for the code and the result) [Screenshot 2023-07-23 at 9.49.33 AM] [Screenshot 2023-07-23 at 9.50.10 AM] Can someone help me understand why this difference?

Hi @Jyotendra , just adding to @ArjenEx ’s explanation, you need to remember that the “.” in regex means “any single character” unless it is escaped or, as in the explanation already given entered in square brackets. So your regex “[0-9]+.[0-9]{2}” can be read as: “match a sequence of 1 or more digits followed by any character followed by 2 digits”. And if you read it that way you can see that all of your examples match as follows (I have spaced out to highlight possible components parts which allow the match to be true): 225 . 00 21 : 46 315921851 3 08 9 2 11 the regex [0-9]+\.[0-9]{2} would also work (although as noted earlier, when entered in nodes such as string manipulation, it would have to be “double escaped” as "[0-9]+\\.[0-9]{2}"

Difference in results for Regexmatcher vs python Script

KNIME Analytics Platform

mlauber71 July 23, 2023, 4:34am 2

@Jyotendra

2 Likes