Feature Request: Support for Multiple Delimiters in Cell Splitter Node

Feedback & Ideas
1

Dear KNIME Development Team,

I hope this message finds you well. I am writing to suggest an enhancement to the Cell Splitter node in the KNIME Analytics Platform, which I believe would greatly benefit users who frequently perform text transformations during data processing.

Currently, the Cell Splitter node allows for splitting cells based on a single delimiter. While it is possible to replace multiple delimiters with a single delimiter using the String Manipulation node before applying the Cell Splitter node, this additional step can be time-consuming and less efficient, especially when dealing with large datasets or complex workflows.

Proposed Enhancement:

Add an option to the Cell Splitter node to allow the use of multiple delimiters for splitting cells.

Users should be able to specify a list of delimiters (e.g., commas, semicolons, pipes) that the node will recognize and use for splitting the cell contents in one step.

Benefits:

Streamlined workflows by reducing the need for intermediate steps.

Improved efficiency in data transformation processes, particularly in text transformations which are common and frequently used.

Enhanced user experience by providing more flexibility and control over data splitting operations.

I believe this enhancement will significantly enhance the functionality of the Cell Splitter node and make the KNIME Analytics Platform even more powerful for data analysts and researchers.

Thank you for considering this feature request. I appreciate the continued efforts of the KNIME development team in providing a robust and user-friendly analytics platform. I look forward to any updates regarding this enhancement.

Best regards,
Charm

2

Hi, @Charm_Myae
You can use String Replacer or String Manipulation replace anything(regex can replace them to delimiter at once) to one type of delimiter, then split later :partying_face: :partying_face: :partying_face:
This only adds one node, and most importantly, you can use it now

3 Likes
3

Hi @HaveF ,

Thank you very much for your suggestion and positive feedback! :grinning::grinning::grinning:

I agree that using the String Replacer or String Manipulation node to replace multiple delimiters with a single delimiter before splitting is a viable solution and a valuable workaround that can be used right now. However, my request for the proposed enhancement aims to streamline this process by integrating the capability directly into the Cell Splitter node. This would allow users to perform the operation in a single step, making workflows more efficient and reducing the need for additional nodes.

While the current method works well, having the option to use multiple delimiters directly within the Cell Splitter node would be a more user-friendly and time-saving feature, especially for those who frequently perform text transformations.

Thank you again for your input, and I appreciate the ongoing improvements to KNIME!

Best regards,
Charm

1 Like