regex for Row Filter knote

KNIME Analytics Platform
1

I am searching for corporations (GmbH) in the Name field. This string can appear at different positions in the string. Example: Hans GmbH; Hans GmbH & Co KG; HansGmbH; Hans GmbH für Dienstleistungen. I have tried it so far with https://regex101.com (regex101: build, test, and debug regex). It seems to work there. But I can’t manage to get this regex into a Row Filter node in Knime. I always get an empty set as a result. It’s probably just a small error, but I can’t find the solution for Knime. Can anyone give me a hint?

2

Hey @TimTim36,

can you share your expression here? One thing that might be the issue is that you need to double \ characters since Java uses \ as an escape character itself and only one \ would not be recognized.
For example, if you use \s to recognize a whitespace character you would need to use \\s instead.

Best,
Julian

3

Hi, of course here is the statement:(GmbH)((?!&| &)(?! u.| Co))
and also my test group:
Hans Peter GmbH Maltermeisterei
Hans GmbH
Hans GmbH & Co. KG
Hans GmbH&CoKG
HansGmbH
Hans GmbH & Co KG
Stefan GmbH Co KG
I am only looking for the match. Thanks for the help!!

4

Hi @TimTim36
I think you can also use this “wildcard” to do this:
image

1 Like
5

Thank you, that’s what I thought at first, but in the result I had all the GmbH & Co KG included.However, I am looking for corporations and not for partnerships. Therefore, I tried to limit my hits to the GmbHs via a negative quantity(?!&| &). However, I obviously cannot pass the syntax correctly.

6

@TimTim36 Did you try this:
image

5 Likes
7

I was a bit desperate but you made my day. Thank you very much. It works.
Best regards

2 Likes
8

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