Icon

20220210 Pikairos How to Split 1 Column to 9 Columns using regex full

20220210 Pikairos How to Split 1 Column to 9 Columns using regex

There has been no description set for this workflow's metadata.

Your Datastrip( removeDuplicates(replace( replace(replace( $Col 0$, "", "\t"), "", "\t"), "", "\t")))Filter outunnecessary rowsSplit rowsbased on \ttabsregexReplace($$CURRENTCOLUMN$$, "(.+)-.*$", "-$1")NOT ( $IDENTIFIER$ LIKE "0*")=> $IDENTIFIER$Separatethe InitialIDENTIFIERPrevious Valueto replaceMissing ValuesNOT ( MISSING $IDENTIFIER$)=> $THE_REST$Join IDENTIFIER & TESTto Number ColumnsTable Creator String Manipulation Row Splitter Cell Splitter ExtractColumn Header Double To Int String Manipulation(Multi Column) String To Number Rule Engine Cell SplitterBy Position Missing Value Rule Engine Joiner Your Data strip( removeDuplicates(replace( replace(replace( $Col 0$, "", "\t"), "", "\t"), "", "\t")))Filter outunnecessary rowsSplit rowsbased on \ttabsregexReplace($$CURRENTCOLUMN$$, "(.+)-.*$", "-$1")NOT ( $IDENTIFIER$ LIKE "0*")=> $IDENTIFIER$Separatethe InitialIDENTIFIERPrevious Valueto replaceMissing ValuesNOT ( MISSING $IDENTIFIER$)=> $THE_REST$Join IDENTIFIER & TESTto Number ColumnsTable Creator String Manipulation Row Splitter Cell Splitter ExtractColumn Header Double To Int String Manipulation(Multi Column) String To Number Rule Engine Cell SplitterBy Position Missing Value Rule Engine Joiner

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: Molina
Created at: 2022-02-10
On NodePit since: 2022-02-10
Last update: 2024-04-27
Created with KNIME version: v4.4.1

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

Try NodePit Runner!