Splits the content of a selected column into several separate new
columns. The data is always split at the same position(s) specified in
the node's dialog. It appends a fixed number of columns to the input
table, each carrying one part of the original column. The number of
appended columns equals the number of specified split points plus one.
If the data in the selected column is shorter than the specified split
point, the corresponding result column contains an empty string. Also
missing values in the selected column will create empty strings in the
result columns.
Options
Popular Predecessors
- Cell Splitter8 %
Row Filter (deprecated)6 %- String Manipulation3 %
- Excel Reader3 %
- Cell Splitter By Position3 %
- Column Filter3 %
- CSV Reader3 %
- File Reader2 %
Line Reader2 %- Path to String2 %
- GroupBy2 %
Column Rename2 %- Number to String2 %
- Joiner2 %
- Rule-based Row Filter1 %
- Concatenate1 %
- Sorter1 %
Table Row to Variable1 %Joiner1 %String To Number1 %- Missing Value1 %
Row Splitter (deprecated)1 %Table Row To Variable Loop Start< 1 %XLS Reader< 1 %- Math Formula< 1 %
Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %- Rule Engine< 1 %
- Rule-based Row Splitter< 1 %
Table Reader< 1 %- Table Creator< 1 %
Column Appender< 1 %- Duplicate Row Filter< 1 %
Variable to Table Row< 1 %- Column Resorter< 1 %
- String to Number< 1 %
Loop End< 1 %- String Manipulation (Multi Column)< 1 %
Database Reader< 1 %- String to Date&Time< 1 %
- Loop End< 1 %
- Regex Substring< 1 %
Recursive Loop Start< 1 %- Missing Value Column Filter< 1 %
- String Splitter (Regex)< 1 %
- Date&Time to String< 1 %
Table Writer< 1 %Variable to Table Column< 1 %- Conditional Box Plot (legacy)< 1 %
- Variable to Table Column< 1 %
CSV Reader< 1 %- Column Combiner< 1 %
- Column Aggregator< 1 %
- Date&Time Shift< 1 %
- String to Date/Time (legacy)< 1 %
- Tika Parser< 1 %
- Date&Time to legacy Date&Time< 1 %
- Table Column to Variable< 1 %
- Data Explorer< 1 %
List Files< 1 %Concatenate (Optional in)< 1 %Cell Replacer< 1 %- Constant Value Column< 1 %
- Partitioning< 1 %
- String Replacer< 1 %
- SDF Reader< 1 %
- Java Snippet (simple)< 1 %
- Value Filter (legacy)< 1 %
- Category to Number< 1 %
- Column to Grid< 1 %
- Line Reader< 1 %
- List Files/Folders< 1 %
- Date&Time Part Extractor< 1 %
- RDKit Canon SMILES< 1 %
- Split Collection Column< 1 %
Table Column to Variable< 1 %- Column Merger< 1 %
- Column Rename (Regex)< 1 %
- Reference Row Filter< 1 %
- Column Splitter< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- XPath< 1 %
- Binary Objects to Strings< 1 %
- Add Empty Rows< 1 %
- One to Many< 1 %
- Cross Joiner< 1 %
- Pivot< 1 %
- Value Counter< 1 %
- DB Reader< 1 %
- DB Query Reader< 1 %
- Date&Time Difference< 1 %
- Table Row to Variable< 1 %
- File Reader (Complex Format)< 1 %
- Table Manipulator< 1 %
- Row Filter (Labs)< 1 %
File Reader< 1 %- Chunk Loop Start< 1 %
- Column List Loop Start< 1 %
- Group Loop Start< 1 %
- Column Renamer (Dictionary)< 1 %
- Nominal Value Row Filter< 1 %
- Normalizer< 1 %
- Number Rounder< 1 %
- RowID< 1 %
- Table Transposer< 1 %
Excel Reader (XLS)< 1 %- Document Data Extractor< 1 %
- Term to String< 1 %
- R Snippet< 1 %
- GET Request< 1 %
- Date&Time-based Row Filter< 1 %
- Create Collection Column< 1 %
- Column Auto Type Cast< 1 %
- Double to Integer< 1 %
- Nominal Value Row Splitter< 1 %
- String Manipulation (Variable)< 1 %
- Column Expressions< 1 %
- Google Sheets Reader< 1 %
- JSON to Table< 1 %
- Create Date&Time Range< 1 %
- Modify Time< 1 %
- Variable to Table Row< 1 %
- Table Reader< 1 %
- Column Appender< 1 %
- Number to String (PMML)< 1 %
- One Row to Many< 1 %
- Top k Row Filter< 1 %
- Collection to String< 1 %
- Regex Extractor< 1 %
- RDKit To InChI< 1 %
- DB Writer< 1 %
- DB Connection Closer< 1 %
- Lag Column< 1 %
- Fingerprint to Binary String< 1 %
- Column Renamer< 1 %
- Numeric Row Splitter< 1 %
Merge Variables< 1 %- Extract URI Info< 1 %
- Wait...< 1 %
- Fixed Width File Reader< 1 %
- Column Name Extractor< 1 %
- Statistics< 1 %
Parquet Reader< 1 %- Date&Time Input (legacy)< 1 %
Read FASTA< 1 %Scorer< 1 %- R Source (Table)< 1 %
Extract Date&Time Fields< 1 %- Date Field Extractor (legacy)< 1 %
- Binner (Dictionary)< 1 %
- Subset Matcher< 1 %
Read Excel Sheet Names (XLS)< 1 %- Table View (JavaScript)< 1 %
Python Script (1⇒1)< 1 %- HTTP Result Data Extractor< 1 %
- Files/Folders Meta Info< 1 %
Regex Extractor< 1 %- Loop End (Column Append)< 1 %
- Linear Regression Learner< 1 %
- Auto-Binner< 1 %
- Case Converter< 1 %
- Inverter< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Time to String (legacy)< 1 %
- URL to File Path< 1 %
- Try (Data Ports)< 1 %
Table Row to Variable< 1 %Counting Loop Start< 1 %- Polynomial Regression Learner< 1 %
Number To String (PMML)< 1 %- IF Switch< 1 %
- Sentence Extractor< 1 %
- RDKit Fingerprint< 1 %
- Date Extractor< 1 %
Hash Calculator< 1 %Database Looping< 1 %Generic Loop Start< 1 %- Scorer< 1 %
- Rule Engine (Dictionary)< 1 %
CASE Switch Data (Start)< 1 %- Multiple MolImporter< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
- Decision Tree Predictor< 1 %
Cell Splitter< 1 %Number To String< 1 %- Reference Row Splitter< 1 %
String Replace (Dictionary)< 1 %- OpenBabel< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet Row Filter< 1 %
Document Data Extractor< 1 %Strings To Document< 1 %- JSON Path< 1 %
- Extract Time Window (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
MapzenGeocoder< 1 %- Feed Parser< 1 %
Execute JavaScript< 1 %Input File< 1 %- Create Well Position< 1 %
- Number Formatter< 1 %
- List Remote Files (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- URI to String< 1 %
Variable to Table Column< 1 %Table Column to Variable< 1 %Table Column to Variable< 1 %- Read Images< 1 %
Database Connection Table Reader< 1 %Line Reader< 1 %- Java Snippet< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- HiLite Row Splitter< 1 %
- Interactive HiLite Collector< 1 %
- One to Many (PMML)< 1 %
String To Number (PMML)< 1 %- String to Number (PMML)< 1 %
- Row Sampling< 1 %
- Target Shuffling< 1 %
- Empty Table Switch< 1 %
- Data Generator< 1 %
- Color Manager< 1 %
- Shape Appender< 1 %
- SDF Extractor< 1 %
- SDF Stripper< 1 %
- Empty Table Creator< 1 %
- Distance Matrix Calculate< 1 %
- Model to Cell< 1 %
- PMML to Cell< 1 %
- H2O to Table< 1 %
- PDF Parser< 1 %
- POS Tagger< 1 %
- Strings to Document< 1 %
- Column Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- String Input (legacy)< 1 %
MongoDB Reader< 1 %- UNIX Timestamp to Date&Time< 1 %
Location Extractor< 1 %- MapQuest Geocoder< 1 %
- File Meta Info (legacy)< 1 %
Variable to Table Row< 1 %Simple File Reader< 1 %Interval Loop Start< 1 %- Table Row to Variable Loop Start< 1 %
- Numeric Binner< 1 %
- Domain Calculator< 1 %
- Reference Column Filter< 1 %
- Filter Apply Row Splitter< 1 %
- Row Splitter (Labs)< 1 %
- Rank< 1 %
- Shuffle< 1 %
- Random Matcher< 1 %
- Tika Parser URL Input< 1 %
- Wildcard Tagger< 1 %
- Bag Of Words Creator< 1 %
- String to Path< 1 %
- String Configuration< 1 %
- Column Selection Widget< 1 %
XML Reader< 1 %- Hash Calculator< 1 %
- Extract Text< 1 %
Views
- This node has no views
Workflows
01_Parameter_Optimization_(Table)_Component_on_Random_ForestKNIME Hub- 01. Datenimport und VorbereitungKNIME Hub
- 02. Karte, Basisvisualisierungen Balkendiagramme diverse Faktoren x Preis und Preis_SQFKNIME Hub
- 03_ETL_Energy_autocorr_statsKNIME Hub
- 03_ETL_Energy_autocorr_statsKNIME Hub
- Show all 142 workflows
Links
- Regex splitby HansS on 2021-09-19forum.knime.com/p/134955
- linking one line of the test dataset to a text dataset without primary keyby AnotherFraudUser on 2020-05-30forum.knime.com/p/92963
- how can I split a text file in column by a character calculation numberby HansS on 2020-04-03forum.knime.com/p/86365
- XLSX Writer :The maximum length of cell contents (text) is 32,767 charactersby AnotherFraudUser on 2022-11-09forum.knime.com/p/174705
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.