Icon

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")Table Creator String Manipulation Row Splitter Cell Splitter ExtractColumn Header Double To Int String Manipulation(Multi Column) String To Number Your Data strip( removeDuplicates(replace( replace(replace( $Col 0$, "", "\t"), "", "\t"), "", "\t")))Filter outunnecessary rowsSplit rowsbased on \ttabsregexReplace($$CURRENTCOLUMN$$, "(.+)-.*$", "-$1")Table Creator String Manipulation Row Splitter Cell Splitter ExtractColumn Header Double To Int String Manipulation(Multi Column) String To Number

Nodes

Extensions

Links