Line Chopper

Manipulator

This node takes a string that consists of tokens which are separated by a certain patter (e.g. TAB, space, etc.) and separates a certain number of these tokens from the beginning of the string. It converts them either in floating point numbers or keeps them as strings. The new values are stored in one new column (as a collection or a vector) or each in a separate new column. If the string consists of more than the extracted tokens, the remaining part of the string can be stored in a new column for further processing.
The string must be comprised of simple tokens; there is no support for quoted tokens, different decimal separators, or comment lines in the file.
The node operates row-based. It can be executed in streaming mode.

Input Ports

  1. Type: Data
    DataTable with column to extract tokens from

Output Ports

  1. Type: Data
    DataTable with additional column(s) carrying the extracted items from the input column

Extension

This node is part of the extension

KNIME Nodes for Wide Data (many columns)

v4.0.0

Short Link

Drag node into KNIME Analytics Platform