Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Cell Splitter
NodeNode / Manipulator

Cell Splitter

Manipulation Column Split & Combine
Drag & drop
Like
Copy short link

This node uses a user-specified delimiter character to split the content of a selected column into parts. It appends either a fixed number of columns to the input table, each carrying one part of the original column, or a single column containing a collection (list or set) of cells with the split output. It can be specified whether the output consists of one or more columns, only one column containing list cells, or only one column containing set cells in which duplicates are removed.
If the column contains more delimiters than needed (leading to more parts than appended columns are available) the additional delimiters are ignored (resulting in the last column containing the unsplit rest of the column).
If the selected column contains too few delimiters (leading to less parts than expected), empty columns will be created in that row.
Based on the delimiters and the resulting parts the collection cells can have different sizes. The content of the new columns will be trimmed if specified (i.e. leading and trailing spaces will be deleted).

Node details

Input ports
  1. Type: Table
    Input Table
    Input data table with column containing the cells to split
Output ports
  1. Type: Table
    Output Table
    Output data table with additional columns.

Extension

The Cell Splitter node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Deduplicate String
    Deduplicate Collection String
    +1
    Remove all duplicate items in a string
    hanss > Public > forum_flows > Deduplicate String
  2. Go to item
    Remove Duplicatess from cell with comma separated values
    Remove Duplicatess from cell with comma separated values
    mlauber71 > Public > forum > kn_forum_fb_remove_cell_duplicatess
  3. Go to item
    Combine Three Consecutive Columns
    This workflow shows how to solve the following problem: If I have in different columns A,…
    kathrin > Forum Questions > Combine Three Consecutive Columns
  4. Go to item
    Word Extraction
    elsamuel > Public > Word Extraction
  5. Go to item
    turn columns into rows
    duristef > Public > solutions > 20220221_turn_columns_into_rows
  6. Go to item
    Obfuscate email user
    bruno29a > Public > Forum > Obfuscate email user
  7. Go to item
    OnePagePerLine
    BIRT Powerpoint Pptx
    BIRT Example for adding one page per line
    iris > Public > ExamplesForTheForum > OnePagePerLine
  8. Go to item
    Z_023_Cell splitting
    tommy > Public > Z_023_Cell splitting
  9. Go to item
    column manipulations
    elsamuel > Public > column manipulations
  10. Go to item
    ColumnToRow_Trying
    raomohsinkhan > Public > ColumnToRow_Trying
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits