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).
Options
Popular Successors
- Column Filter11 %
- String Manipulation7 %
- Cell Splitter5 %
- Joiner5 %
- Ungroup4 %
- GroupBy4 %
Row Filter (deprecated)3 %- Unpivot3 %
- Rule Engine3 %
- Column Renamer3 %
- String to Date&Time3 %
- Column Expressions (legacy)2 %
- Excel Writer2 %
- Number to String2 %
- Rule-based Row Filter2 %
- Table Manipulator2 %
- Association Rule Learner1 %
- Column Combiner1 %
- Table Transposer1 %
- Missing Value1 %
- Math Formula1 %
Row Splitter (deprecated)1 %- Cell Splitter By Position1 %
- String to Number1 %
- Column Resorter< 1 %
- String Manipulation (Multi Column)< 1 %
- Rule-based Row Splitter< 1 %
- Pivot< 1 %
- Column Aggregator< 1 %
- Concatenate< 1 %
- Duplicate Row Filter< 1 %
- Reference Row Filter< 1 %
- String Replacer< 1 %
- Sorter< 1 %
- Column Merger< 1 %
- Association Rule Learner (Borgelt)< 1 %
- CSV Writer< 1 %
- Constant Value Column< 1 %
- Column Splitter< 1 %
- String Splitter (Regex)< 1 %
- Column Rename (Regex)< 1 %
- Java Snippet< 1 %
- Loop End< 1 %
- Cross Joiner< 1 %
- Table Row to Variable Loop Start< 1 %
- Create Collection Column< 1 %
- Column List Loop Start< 1 %
- Split Collection Column< 1 %
Cell Replacer< 1 %- Subset Matcher< 1 %
- Date&Time Part Extractor< 1 %
- Chunk Loop Start< 1 %
- RowID< 1 %
- Column Appender< 1 %
- Molecule Type Cast< 1 %
- Column Filter Configuration< 1 %
- Variable to Table Column< 1 %
- Date&Time Difference< 1 %
- Group Loop Start< 1 %
- One to Many< 1 %
- Value Lookup< 1 %
- Missing Value Column Filter< 1 %
- Nominal Value Row Filter< 1 %
- Date&Time-based Row Filter< 1 %
- Category to Number< 1 %
- Value Counter< 1 %
- Row to Column Names< 1 %
- OSM Map View< 1 %
- Value Filter (legacy)< 1 %
- Python Script (legacy)< 1 %
- Regex Extractor< 1 %
Table Column to Variable< 1 %- Case Converter< 1 %
- Column Name Extractor< 1 %
- Filter Apply< 1 %
Joiner< 1 %- Counter Generation< 1 %
- Term to String< 1 %
- Scatter Plot (JavaScript)< 1 %
- Partitioning< 1 %
- Rank< 1 %
- Date&Time to String< 1 %
- RDKit Molecule Highlighting< 1 %
- Column Auto Type Cast< 1 %
Column Rename< 1 %- CASE Switch Start< 1 %
Python Script (2⇒1)< 1 %- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Number Rounder< 1 %
- String Matcher< 1 %
- 2D/3D Scatterplot< 1 %
- Reference Row Splitter< 1 %
- Missing Value (Apply)< 1 %
- String to Number (PMML)< 1 %
- String to Path< 1 %
Python Script (1⇒1)< 1 %- Collection Size< 1 %
- Table Row to Variable< 1 %
- Decision Tree Learner< 1 %
- Regression Predictor< 1 %
- Dictionary Tagger< 1 %
- String to URI< 1 %
- Loop End (Column Append)< 1 %
- Distance Matrix Pair Extractor< 1 %
Cell Splitter< 1 %- Column Renamer (Dictionary)< 1 %
- Linear Correlation< 1 %
- Domain Calculator< 1 %
- Bar Chart< 1 %
- Java Snippet (simple)< 1 %
- JSON Transformer< 1 %
- Object Inserter< 1 %
- Insert into List< 1 %
- Table Creator< 1 %
Loop End (2 ports)< 1 %Recursive Loop Start (2 ports)< 1 %- Reference Column Filter< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
CASE Switch Data (End)< 1 %- OpenBabel< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Line Plot (JavaScript)< 1 %
- Value Selection Widget< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Remove Empty Rows< 1 %
Table Row to Variable< 1 %Loop End< 1 %- Decision Tree Predictor< 1 %
- Lag Column< 1 %
- Double to Integer< 1 %
- Interactive HiLite Collector< 1 %
- Nominal Value Row Splitter< 1 %
- Row Filter (Labs)< 1 %
- Row Splitter (Labs)< 1 %
- Set Operator< 1 %
String Replace (Dictionary)< 1 %- Target Shuffling< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
- DB Table Creator< 1 %
- Cell to Model< 1 %
- Excel Cell Updater< 1 %
- Category to Class< 1 %
- Sentence Extractor< 1 %
- Tag Cloud (JavaScript)< 1 %
- Columns to JSON< 1 %
- Corpus Creator< 1 %
- List To Set< 1 %
- Regex Substring< 1 %
- Binary Objects to Files< 1 %
- Extract URI Info< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
Table Writer< 1 %Recursive Loop End< 1 %- Recursive Loop Start< 1 %
- Linear Regression Learner< 1 %
- PCA Compute< 1 %
- PCA< 1 %
String To Number< 1 %- Number to String (PMML)< 1 %
- Shuffle< 1 %
- String Manipulation (Variable)< 1 %
- String Replacer (Dictionary)< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Extract Table Dimension< 1 %
- Interactive Histogram (legacy)< 1 %
- Histogram< 1 %
- DB Loader< 1 %
- DB Writer< 1 %
- String Distances< 1 %
- Bar Chart (JavaScript)< 1 %
Table to PDF< 1 %- OSM Map to Image< 1 %
Excel Writer (XLS)< 1 %- Markup Tag Filter< 1 %
- Path to String< 1 %
- Column Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- String to Duration< 1 %
- Date&Time Shift< 1 %
- Modify Time< 1 %
- Molecule to CDK< 1 %
- Fingerprint Similarity< 1 %
- Date Extractor< 1 %
- Coordinate to Latitude/Longitude< 1 %
- Hash Calculator< 1 %
Flow Variable End IF< 1 %- Collection to String< 1 %
- Set To List< 1 %
- Advanced MolConverter< 1 %
- R-group Decomposition< 1 %
- String to Table< 1 %
- Binary Objects to Strings< 1 %
- Strings to Binary Objects< 1 %
Table Row To Variable Loop Start< 1 %CSV Writer< 1 %- Table Writer< 1 %
- Counting Loop Start< 1 %
Counting Loop Start< 1 %Table Row To Variable Loop Start< 1 %- Naive Bayes Predictor< 1 %
- Hierarchical Clustering< 1 %
- k-Means< 1 %
- DBSCAN< 1 %
- SOTA Predictor< 1 %
- Random Forest Learner< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Binner (Dictionary)< 1 %
- Create Bit Vector< 1 %
- Expand Bit Vector< 1 %
- Column Comparator< 1 %
- Number to Category (Apply)< 1 %
- Column to Grid< 1 %
- Many to One< 1 %
Linear Correlation< 1 %- Table Validator< 1 %
- Filter Apply Row Splitter< 1 %
- HiLite Row Splitter< 1 %
- Normalizer< 1 %
- Column Filter (PMML)< 1 %
- Reference Column Resorter< 1 %
- Row Aggregator< 1 %
- Numeric Row Splitter< 1 %
- Row Sampling< 1 %
- Cell Extractor< 1 %
- Table Cropper< 1 %
- Table Difference Finder< 1 %
- Ruleset Editor< 1 %
- Numeric Outliers< 1 %
- Statistics< 1 %
- CASE Switch End< 1 %
CASE Switch Variable (Start)< 1 %- Empty Table Switch< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Send Email< 1 %
- Crosstab< 1 %
- Line Plot (legacy)< 1 %
- Color Manager< 1 %
- Interactive Table (legacy)< 1 %
- Heatmap< 1 %
- Line Plot< 1 %
- Statistics View< 1 %
- Table View< 1 %
- Table to Spark< 1 %
- DB Insert< 1 %
- Random Number Assigner< 1 %
- One Row to Many< 1 %
- Java Distance< 1 %
- Similarity Search< 1 %
- Item Set Finder (Borgelt)< 1 %
- Math Formula (Multi Column)< 1 %
- HeatMap (JFreeChart)< 1 %
Excel Writer (XLS)< 1 %- Excel Reader< 1 %
- Java Snippet Row Filter< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Case Converter< 1 %
- Number Filter< 1 %
- Stop Word Filter< 1 %
- POS Tagger< 1 %
- Strings to Document< 1 %
- String to Term< 1 %
- Files/Folders Meta Info< 1 %
- Transfer Files (Table)< 1 %
- Google Sheets Updater< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Selection (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- String to JSON< 1 %
- Table to JSON< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- GET Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Modify Date< 1 %
- Time Difference (legacy)< 1 %
- Extract Time Window (legacy)< 1 %
- Moving Aggregator< 1 %
- Moving Average< 1 %
- String to Date/Time (legacy)< 1 %
- XPath< 1 %
- Mass Calculator< 1 %
- RDKit From InChI< 1 %
- RDKit Fingerprint< 1 %
- Text Classifier Learner< 1 %
- Latitude/Longitude to Coordinate< 1 %
Regex Extractor< 1 %- HTTP Retriever< 1 %
- Speedy SMILES Convert to Scaffold< 1 %
- MolConverter< 1 %
- Try (Data Ports)< 1 %
- Read Images< 1 %
Recursive Loop Start< 1 %- Add Empty Rows< 1 %
- Top k Row Filter< 1 %
- Conditional Box Plot (legacy)< 1 %
- DB Connector< 1 %
- k-Medoids< 1 %
- Cell to PMML< 1 %
- Variable Expressions (legacy)< 1 %
- Java IF (Table)< 1 %
- RegEx Filter< 1 %
- Bag Of Words Creator< 1 %
- JSON Schema Validator< 1 %
- Extract Duration Fields< 1 %
- Row Splitter (col+)< 1 %
- HTML Parser< 1 %
- Benchmark Start< 1 %
- Range Splitter< 1 %
- File Meta Info (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Parameterized Database Query< 1 %- Extract Missing Value Cause< 1 %
- Low Variance Filter< 1 %
- One to Many (PMML)< 1 %
- HiLite Table (legacy)< 1 %
- Histogram (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- SDF Writer< 1 %
- DB Update< 1 %
- Box Plot (JavaScript)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Math Formula (Variable)< 1 %
Excel Sheet Appender (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- Send to Tableau Server< 1 %
- Keygraph Keyword Extractor< 1 %
- Replacer< 1 %
- Document Vector< 1 %
- Tile View (JavaScript)< 1 %
- Data Row to Image< 1 %
- R View (Table)< 1 %
- Date/Time Shift (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Column to XML< 1 %
- String to XML< 1 %
- RDKit Interactive Table< 1 %
- RDKit Salt Stripper< 1 %
- Google Address Geocoder< 1 %
Location Extractor< 1 %- MapQuest Geocoder< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Duplicate Filter< 1 %
- Canonical SMILES< 1 %
- Fingerprint From Set Bits list< 1 %
- Distance (1-D)< 1 %
- Trim Table< 1 %
- Create Well Position< 1 %
- Expand Well Position< 1 %
Element Selector< 1 %- Delete Files (legacy)< 1 %
- Active Branch Inverter< 1 %
Database Writer< 1 %- Line Reader< 1 %
Table Reader< 1 %- Java Edit Variable< 1 %
Variable Condition Loop End< 1 %Generic Loop Start< 1 %- RProp MLP Learner< 1 %
- Logistic Regression Predictor< 1 %
- Polynomial Regression Learner< 1 %
Column Appender< 1 %Column Filter< 1 %- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Many to One (PMML)< 1 %
- Ruleset Predictor< 1 %
- Rank Correlation< 1 %
CASE Switch Data (Start)< 1 %- Timer Info< 1 %
- Box Plot (legacy)< 1 %
- Random Label Assigner< 1 %
- Line Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Geo-Coordinate Row Filter< 1 %
Excel Sheet Appender (XLS)< 1 %Tableau Writer (Hyper)< 1 %- Tableau Writer< 1 %
- DF< 1 %
- Tika Language Detector< 1 %
- Dictionary Tagger (Multi Column)< 1 %
- Stanford Tagger< 1 %
- Unique Term Extractor< 1 %
- Path to URI< 1 %
Column Filter Configuration< 1 %- Lift Chart (JavaScript)< 1 %
- Window Loop Start< 1 %
XGBoost Linear Ensemble Learner< 1 %- Table to HTML String< 1 %
- Sugar Remover< 1 %
- RDKit Substructure Counter< 1 %
- CIR< 1 %
Write MDB< 1 %- Standardizer< 1 %
- Substructure Matcher< 1 %
- Correlation Pairs To Matrix< 1 %
- Total Count< 1 %
- Run Garbage Collector< 1 %
- Append to Collection< 1 %
- Save File Locally< 1 %
- PDB Sequence Extractor< 1 %
- URL Encode< 1 %
- Plate Row Converter< 1 %
- Number Formatter< 1 %
- Split Interval< 1 %
- Range Filter< 1 %
- Matlab Snippet< 1 %
- Elemental Analysis< 1 %
- Similarity Calculator< 1 %
- Text Extractor< 1 %
- ARIMA Learner< 1 %
- URL to Audio< 1 %
Binary Objects to Files< 1 %- Copy/Move Files (legacy)< 1 %
- URI to String< 1 %
- URL to File Path< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %Variable to Table Column< 1 %- Extract Variables (Data)< 1 %
Table Column to Variable< 1 %- Variable to Table Row< 1 %
- Table to Image< 1 %
Database SQL Executor< 1 %Database Looping< 1 %Interval Loop Start< 1 %- Recursive Loop End< 1 %
- Variable Loop End< 1 %
Naive Bayes Learner< 1 %- Fuzzy Rule Learner< 1 %
- PNN Learner (DDA)< 1 %
- Silhouette Coefficient< 1 %
- MDS (DistMatrix)< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA Compute< 1 %PCA< 1 %- Logistic Regression Learner< 1 %
- Scorer< 1 %
Scorer< 1 %- Gradient Boosted Trees Predictor< 1 %
- Tree Ensemble Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Create Byte Vector< 1 %
- Expand Byte Vector< 1 %
Number To String< 1 %- Correlation Filter< 1 %
- Edit Nominal Domain< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Edit Numeric Domain< 1 %
- Filter Definition Merger< 1 %
- Normalizer (PMML)< 1 %
String To Number (PMML)< 1 %- Nominal Probability Distribution Creator< 1 %
- Nominal Probability Distribution Splitter< 1 %
Rank Correlation< 1 %- One-way ANOVA< 1 %
- Single sample t-test< 1 %
- Independent groups t-test< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Lift Chart (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Shape Manager< 1 %
- Size Manager< 1 %
- ROC Curve (legacy)< 1 %
- Parallel Chunk End< 1 %
- Parallel Chunk Start< 1 %
- MySQL Connector< 1 %
- DB Delete (Table)< 1 %
- Parameterized DB Query Reader< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Item Inserter< 1 %
- Random Matcher< 1 %
- Bit Vector Distances< 1 %
- Numeric Distances< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Learner< 1 %
- Autocomplete Text Widget< 1 %
- Histogram (JavaScript)< 1 %
- MoSS MCSS Molecule Similarity< 1 %
- External Tool< 1 %
- Bar Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Index Query< 1 %
XLS Sheet Appender< 1 %Send to Tableau Server (Hyper)< 1 %Tableau Writer (TDE)< 1 %- Word Vector Apply (legacy)< 1 %
- Word2Vec Learner (legacy)< 1 %
- Term Co-Occurrence Counter< 1 %
- TF< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer< 1 %
- Punctuation Erasure< 1 %
- Document Data Extractor< 1 %
- Document Vector Hashing< 1 %
- Tags to String< 1 %
- Term to Structure< 1 %
- Tag Cloud< 1 %
- Map viewer< 1 %
- Google Sheets Writer< 1 %
- Integer Slider Configuration< 1 %
- Column Selection Configuration< 1 %
- Scorer (JavaScript)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Slider Widget< 1 %
- JSON Column Combiner< 1 %
- Image Viewer< 1 %
- Ilastik Headless (Pixel classification)< 1 %
- Feature Inserter< 1 %
- Assign Partition< 1 %
Python Script (1⇒2)< 1 %- Python View (legacy)< 1 %
- POST Request< 1 %
- Table Difference Checker< 1 %
- Time Field Extractor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- XML Column Combiner< 1 %
XML Writer< 1 %- RDKit Canon SMILES< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit From IUPAC< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit To InChI< 1 %
RDKit Structure Normalizer< 1 %- RDKit Substructure Filter< 1 %
Map Viewer< 1 %Reverse Location Lookup< 1 %- Geo Distances< 1 %
- String Similarity< 1 %
- Trim Image Whitespace< 1 %
- HTML Node to Text< 1 %
- Find Elements< 1 %
- Quit WebDriver< 1 %
- Extract Text< 1 %
Views
- This node has no views
Workflows
justknimeit-27KNIME Hub- _Looping_over_all_columns_and_manipulation_of_each 1KNIME Forum
- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
- Show all 2583 workflows
Links
- How to split a multirow string in different rows?by qqilihq on 2019-12-11forum.knime.com/p/76741
- Compare Two Sets [Arrays]by AnotherFraudUser on 2020-05-17forum.knime.com/p/91527
- Extract substring from pattern - RegEx perhaps?by armingrudd on 2019-10-23forum.knime.com/p/73042
- Error with Association Rules Learnerby HansS on 2019-09-27forum.knime.com/p/71215
- How can I remove the words after spaces?by HansS on 2020-05-29forum.knime.com/p/92813
- Show all 19 links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.