regular expression

How can I filter duplicate row id that have this pattern (1) in its name?

Hi @ahmed_gomaa

Does the Duplicate Row Filter helps you out?
gr. Hans

This node filter about the field value not about the row id.

Use the RowID node. Choose the option Append RowID column: Create new column with the RowID values. And then apply the Duplicate Row Filter on this new created column.

1 Like

Hi @ahmed_gomaa

Or you can try the Row Filter node and select “Include row by row ID” and input this regex pattern:
((?!\(1\)).)*

:blush:

1 Like

It works. Thanks. But, what if there is more than one duplicate row ID. In other words, (2), (3), etc.

1 Like

((?!\(\d\)).)*

:blush:

Thanks a lot, you are a professional one. I want to learn about regular expression. what is your recommendation?

1 Like
2 Likes

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