Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • takbb
  • Spaces
  • Public
  • Components
  • Extract Data Table from Delimited Text
ComponentComponent

Extract Data Table from Delimited Text

Brian Bates profile image

Last edited: 

Drag & drop
Like
Use or download
Copy short link
Returns a table based on the delimited text contained in a single text field. e.g. If the text is name|age|city Alan|25|London Brian|23|New York Charlie|30|Sydney then with a delimiter of | This would return a table with the columns "name" "age" "city" and the data aligned in their columns. The main driver for writing this component was the presentation of "sample data" on the forum, where it then takes time to translate the posted data into an actual table. Simply paste the data into the supplied multi-line text field, specify: + column delimiter + row delimiter These can be any value that is acceptable to the Cell Splitter node. Tab can be specified with \t New Line can be specified with \n If you want to use \ as a delimiter, it should also work. There should not be a need to escape but if you have problems, try specifying \\ @takbb Brian Bates v1.3 29 October 2022 - update to handle different datatypes appearing in same column - explicitly converts to String v1.4 30 October 2022 - removes any columns that get created with a column name of <empty_.* which is caused when the column delimiter is initial character

Component details

Output ports
  1. Type: Table
    Data Table
    The data table generated from the supplied table text

Used extensions & nodes

Created with KNIME Analytics Platform version 4.6.3
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.2

    knime
  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.0

    knime
  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.6.0

    knime
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

By using or downloading the component, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits