Icon

Split delimited string, replace and regroup

Splitting a delimited string into a String List, then performing regex to pull out specific parts of the strings and then regrouping, whilst retaining the row and column structure.
ungroup the string listinto individual rowskeep original column nameperform string replacementon the ungrouped (#1) columnto pull out the extensionssample datagroup byoriginal rowIDgenerate unique concatenation of extensionsand unique extensions countappend extensioncolumntidy upsplit delimitedstring into String Liststore originalRowIDprior to ungroupingso we canjoin back laterrename columnafter string splitterUngroup String Replacer Table Creator GroupBy Value Lookup Table Manipulator Cell Splitter RowID Column Renamer ungroup the string listinto individual rowskeep original column nameperform string replacementon the ungrouped (#1) columnto pull out the extensionssample datagroup byoriginal rowIDgenerate unique concatenation of extensionsand unique extensions countappend extensioncolumntidy upsplit delimitedstring into String Liststore originalRowIDprior to ungroupingso we canjoin back laterrename columnafter string splitterUngroup String Replacer Table Creator GroupBy Value Lookup Table Manipulator Cell Splitter RowID Column Renamer

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: BATEB031
Created at: 2024-05-28
On NodePit since: 2024-05-29
Last update: 2024-11-21
Created with KNIME version: v5.2.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!