Enhancement: RegEx cleaning in String Cleaner Node

Description:
So far I’m happy with the String Cleaner node; execution-wise every operation seems to be executed in the order I would expect and it has many useful functionalities. Before the introduction of the String Cleaner node, we internally developed our own cleaning component which had the option to use a RegEx to remove/replace specific patterns in a string. The current “Other characters to remove” operation in the String Cleaner node could be expanded with this option.

Nice to hear this, thank you.
You can use the String Replacer to replace more complex patterns. At the moment it only works with one column, not multiple. Would that be a problem for your use cases, or are the patterns specific to specific columns?

Thanks for your reply @nan , I’m indeed aware of the String Replacer node, but it might be worthwile to have a more powerful “other characters to remove” function in the String Cleaner anyway. For some of our use cases these patterns would indeed not be column specific, so might appear in multiple columns. But, it’s not a deal breaker in any way, just an idea :wink:

1 Like

Hi @ralphkoerse and thank you for your feedback.

We have created a ticket for the feature you suggested: AP-21558

1 Like

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