This Node Is Deprecated — This node is kept for backwards-compatibility, but the usage in new workflows is no longer recommended. The documentation below might contain more information.
Converts strings in a column (or a set of columns) to numbers. If the node fails to parse a string, it will generate a missing cell and append a warning message to the KNIME Console with detailed information.
Options
Popular Predecessors
Cell Splitter6 %XLS Reader6 %String Replace (Dictionary)5 %- RowID5 %
Excel Reader (XLS)5 %- Category to Number3 %
- Decision Tree Predictor3 %
- Value Counter3 %
- Partitioning2 %
Column Appender2 %- Normalizer2 %
- XPath2 %
- R Snippet1 %
- One to Many1 %
- Color Manager1 %
Extract Date&Time Fields1 %Random Forest Predictor1 %- Domain Calculator1 %
Variable to Table Row< 1 %String To Number (PMML)< 1 %Scorer< 1 %- X-Aggregator< 1 %
Naive Bayes Predictor< 1 %- JSON to Table< 1 %
- SVM Predictor< 1 %
- Equal Size Sampling< 1 %
- Logistic Regression Predictor< 1 %
- Date&Time Difference< 1 %
- ARFF Reader< 1 %
- SMOTE< 1 %
Linear Correlation< 1 %- Missing Value (Apply)< 1 %
- Date&Time to legacy Date&Time< 1 %
K Nearest Neighbor< 1 %Gradient Boosted Trees Predictor< 1 %Regression Predictor< 1 %- SDF Reader< 1 %
- Column Filter (legacy)< 1 %
Variable to Table Column< 1 %- Weka Predictor (3.7)< 1 %
Python Script (1⇒1)< 1 %- String to Date&Time< 1 %
- Nominal Value Row Splitter< 1 %
Excel Reader (XLS)< 1 %- Number Formatter< 1 %
- Split Collection Column< 1 %
File Reader< 1 %- Rank< 1 %
Tree Ensemble Predictor< 1 %- Create Collection Column< 1 %
- End IF< 1 %
Gradient Boosted Trees Predictor< 1 %- Linear Regression Learner< 1 %
- Low Variance Filter< 1 %
- Auto-Binner (Apply)< 1 %
- Column Filter< 1 %
- Counter Generation< 1 %
- Add Empty Rows< 1 %
- ROC Curve (legacy)< 1 %
- Case Converter< 1 %
- Chunk Loop Start< 1 %
String To Number< 1 %Joiner< 1 %- Try (Data Ports)< 1 %
- Many to One< 1 %
Column Rename< 1 %- Column Expressions< 1 %
- Google Sheets Reader< 1 %
- Time Difference (legacy)< 1 %
- Fixed Width File Reader< 1 %
Line Reader< 1 %Number To String< 1 %- Numeric Row Splitter< 1 %
- Rule Engine (Dictionary)< 1 %
Read Excel Sheet Names (XLS)< 1 %- Number to Category (Apply)< 1 %
- Regression Predictor< 1 %
Numeric Scorer< 1 %- Simple Regression Tree Predictor< 1 %
- Column Name Extractor< 1 %
- Table Validator (Reference)< 1 %
- GroupBy< 1 %
- Shuffle< 1 %
- String Manipulation (Variable)< 1 %
- One-way ANOVA< 1 %
CASE Switch Data (Start)< 1 %Color Appender< 1 %- Java Snippet Row Filter< 1 %
Python Script (1⇒1)< 1 %- Molecular Properties< 1 %
- Outlier Removal< 1 %
Naive Bayes Learner< 1 %- String Manipulation< 1 %
- Spark to Table< 1 %
- Molecule Type Cast< 1 %
- String Input (legacy)< 1 %
- K Nearest Neighbor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Plate Row Converter< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %CSV Reader< 1 %- Column Comparator< 1 %
- Column Resorter< 1 %
- Table Validator< 1 %
- Reference Column Splitter< 1 %
- String Replacer< 1 %
Rank Correlation< 1 %- Value Filter (legacy)< 1 %
- R to Table< 1 %
- Create Date&Time Range< 1 %
- RDKit Descriptor Calculation< 1 %
- Binary Objects to Strings< 1 %
- String to Number< 1 %
Table Row To Variable Loop Start< 1 %Database Reader< 1 %Random Forest Learner< 1 %- Concatenate< 1 %
- Category to Number (Apply)< 1 %
- Table Transposer< 1 %
Linear Discriminant Analysis< 1 %PMML Ensemble Predictor< 1 %- Strings to Document< 1 %
- Term to String< 1 %
- Mask Date/Time (legacy)< 1 %
- Moving Aggregator< 1 %
- Denormalizer (PMML)< 1 %
- Excel Reader< 1 %
- String Manipulation (Multi Column)< 1 %
- Shapefile Polygon Reader< 1 %
Expand Well Position< 1 %Database Connection Table Reader< 1 %List Files< 1 %Random Forest Predictor< 1 %- Create Bit Vector< 1 %
- Cell Splitter< 1 %
- Rule-based Row Filter< 1 %
- Rule Engine< 1 %
- Ruleset Editor< 1 %
- SAS7BDAT Reader< 1 %
- Legacy Date&Time to Date&Time< 1 %
Extract Outer/InnerHTML< 1 %- Numeric Outliers< 1 %
- Joiner< 1 %
- Table Creator< 1 %
- X-Partitioner< 1 %
PCA< 1 %- Random Forest Learner< 1 %
- Expand Byte Vector< 1 %
Cell Replacer< 1 %- Column Auto Type Cast< 1 %
- Column Aggregator< 1 %
- Lag Column< 1 %
- Column to Grid< 1 %
- Double to Integer< 1 %
- Nominal Value Row Filter< 1 %
Row Splitter (deprecated)< 1 %Row Filter (deprecated)< 1 %- Reference Row Filter< 1 %
- Missing Value< 1 %
- Normalizer (PMML)< 1 %
- Cache< 1 %
- Crosstab< 1 %
- OpenBabel< 1 %
- Document Data Extractor< 1 %
- Integer Input (legacy)< 1 %
- JSON Path< 1 %
- Network Analyzer< 1 %
- R Source (Table)< 1 %
- Date&Time to String< 1 %
- Preset Date/Time (legacy)< 1 %
Variable Loop End< 1 %- Tree Ensemble Predictor< 1 %
- Number to String< 1 %
- Duplicate Row Filter< 1 %
- Extract Missing Value Cause< 1 %
Excel Reader (XLS)< 1 %- Multiple Selections (legacy)< 1 %
- String to Duration< 1 %
- Trim Table< 1 %
Database Looping< 1 %Recursive Loop End (2 ports)< 1 %- SOTA Predictor< 1 %
- Reference Column Filter< 1 %
- Conditional Label Assigner< 1 %
- JPython Function (Legacy)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
Document Data Extractor< 1 %Python Script (2⇒1)< 1 %- Modify Date< 1 %
- RDKit From Molecule< 1 %
- HTTP Result Data Extractor< 1 %
- Fuzzy Rule Predictor< 1 %
- Binner (Dictionary)< 1 %
- Correlation Filter< 1 %
- Edit Nominal Domain< 1 %
- Filter Apply< 1 %
- Random Number Assigner< 1 %
- Similarity Search< 1 %
- H2O to Table< 1 %
- Boolean Input (legacy)< 1 %
- Remove Empty Rows< 1 %
- Join Layout< 1 %
- R Snippet< 1 %
- Java Edit Variable< 1 %
- Group Loop Start< 1 %
Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
Concatenate (Optional in)< 1 %- Pivot< 1 %
- Parallel Chunk End< 1 %
- Random Label Assigner< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- LIBSVMPredictor< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- String to Term< 1 %
- Date/Time Shift (legacy)< 1 %
- Strings to Binary Objects< 1 %
- Naive Bayes Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
- Denormalizer< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Parallel Chunk Start< 1 %
Excel Writer (XLS)< 1 %- Word Vector Apply (legacy)< 1 %
- Google Analytics Query (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Table to JSON< 1 %
- Duration to String< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Fingerprint to Binary String< 1 %
- Example Data< 1 %
- Inject Variables (Data)< 1 %
- Java Snippet< 1 %
Loop End (2 ports)< 1 %- Logistic Regression Learner< 1 %
- Perl Scripting< 1 %
- Cell Splitter By Position< 1 %
- Column Combiner< 1 %
- Column Rename (Regex)< 1 %
- Create Table Structure< 1 %
Double To Int< 1 %- HiLite Row Splitter< 1 %
- Missing Value Column Filter< 1 %
- Sorter< 1 %
- Ungroup< 1 %
- Unpivot< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Box Plot (legacy)< 1 %
PMML Predictor< 1 %Strings To Document< 1 %- Date&Time Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Node Adjacency Matrix< 1 %
- Python Source (legacy)< 1 %
List Box Input (legacy)< 1 %- Date&Time-based Row Filter< 1 %
- Extract Time Window (legacy)< 1 %
- RDKit Fingerprint< 1 %
- HTML Parser< 1 %
- SDF Reader< 1 %
- Load SD-Files (SDF)< 1 %
- InfluxDBConnector< 1 %
- Fingerprint Similarity< 1 %
- URI to String< 1 %
- URL to File Path< 1 %
Database SQL Executor< 1 %- Extract System Properties< 1 %
Backward Feature Elimination End< 1 %- Decision Tree Learner< 1 %
- PMML Gradient Boosted Trees Predictor (Regression)< 1 %
- Edit Numeric Domain< 1 %
- Normalizer (Apply)< 1 %
- Numeric Binner (PMML)< 1 %
- Set Operator< 1 %
- Extract Table Spec< 1 %
- DB Query Reader< 1 %
- PMML Predictor< 1 %
- Frequency Filter< 1 %
- PDF Parser< 1 %
- Modify Time Zone< 1 %
- Delete Files (legacy)< 1 %
- Variable Loop End< 1 %
- Molecule Properties< 1 %
- IScreen< 1 %
- Fingerprint to String< 1 %
Loop End (Upto 6 ports)< 1 %- Load Layout< 1 %
- MolImporter< 1 %
- MolConverter< 1 %
- Create Directory (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Table Reader< 1 %- Loop End (Column Append)< 1 %
Loop End< 1 %Counting Loop Start< 1 %Interval Loop Start< 1 %- Column List Loop Start< 1 %
- PNN Predictor< 1 %
- Cluster Assigner< 1 %
- k-Means< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Association Rule Learner< 1 %
Tree Ensemble Predictor< 1 %Tree Ensemble Learner< 1 %- Random Forest Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Auto-Binner< 1 %
- Numeric Binner< 1 %
- Column Renamer (Dictionary)< 1 %
- Column Merger< 1 %
- Constant Value Column< 1 %
- Cross Joiner< 1 %
- Constant Value Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Reference Row Splitter< 1 %
Number To String (PMML)< 1 %- String Splitter (Regex)< 1 %
- Number Rounder< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
- Target Shuffling< 1 %
- Rule-based Row Splitter< 1 %
- Rule Engine Variable< 1 %
- Statistics< 1 %
- Empty Table Switch< 1 %
- IF Switch< 1 %
- Shape Appender< 1 %
- Shape Manager< 1 %
- DB Reader< 1 %
- TimeDelay Loop End< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Boosting Learner Loop End< 1 %
- Prediction Fusion< 1 %
- Math Formula< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Category to Class< 1 %
- Bag Of Words Creator< 1 %
Document vector< 1 %- Weka Cluster Assigner (3.7)< 1 %
- List Box Input (legacy)< 1 %
- Value Selection (legacy)< 1 %
- Feature Calculator (BETA)< 1 %
- Node Table< 1 %
Python Script (2⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- Date&Time Shift< 1 %
- Modify Time< 1 %
- Date Field Extractor (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- String to Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Fingerprints< 1 %
- RDKit To InChI< 1 %
- String Similarity< 1 %
- ChEMBL-DB Extractor< 1 %
PMI Calculation< 1 %- Fingerprint From Binary String< 1 %
- Fingerprint From Hexadecimal String< 1 %
- Fingerprint CONCATENATE< 1 %
Loop End (3 ports)< 1 %- XML To Table< 1 %
- Plate Heatmap Viewer< 1 %
- Advanced MolConverter< 1 %
- String to Table< 1 %
- Table to String< 1 %
- String to URI< 1 %
- Wait...< 1 %
- Try (Variable Ports)< 1 %
- Create File Name (legacy)< 1 %
Database Row Filter< 1 %Parameterized Database Query< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Generic Loop Start< 1 %- Fuzzy Rule Learner< 1 %
- DBSCAN< 1 %
- MDS (DistMatrix)< 1 %
Random Forest Learner< 1 %Random Forest Learner (Regression)< 1 %Random Forest Predictor (Regression)< 1 %- Gradient Boosted Trees Predictor< 1 %
PMML Gradient Boosted Trees Predictor< 1 %- CAIM Applier< 1 %
- CAIM Binner< 1 %
- Filter Apply Row Splitter< 1 %
- One to Many (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Reference Column Resorter< 1 %
- Paired t-test< 1 %
- Wilcoxon Signed-Rank< 1 %
- Send Email< 1 %
- HiLite Table (legacy)< 1 %
- Extract Color< 1 %
Vertica Connector< 1 %- Fingerprint Bayesian Predictor< 1 %
- One Row to Many< 1 %
- Random Label Assigner (Data)< 1 %
- Cell to PMML< 1 %
- String Matcher< 1 %
- Diacritic Remover< 1 %
- Punctuation Erasure< 1 %
- Replacer< 1 %
- Tag Filter< 1 %
- Tika Parser< 1 %
- Document Vector< 1 %
- Sentence Extractor< 1 %
- Term Neighborhood Extractor< 1 %
- Integer Configuration< 1 %
- Table View (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
Python Script (1⇒2)< 1 %Column Filter QuickForm (legacy)< 1 %- SPARQL Query< 1 %
- Time Generator (legacy)< 1 %
- XGBoost Predictor< 1 %
Hash Calculator< 1 %- Distance (1-D)< 1 %
- JC4XL Reader< 1 %
- Variable to Table Row< 1 %
- CSV Reader< 1 %
Variable Condition Loop End< 1 %- Date&Time Part Extractor< 1 %
Views
- This node has no views
Workflows
00_KNIME_Workshop_basicsKNIME Hub- 01_AnalyticsKNIME Hub
- 01_AnalyticsKNIME Hub
- 01_Data_Preparation_and_CNN_TrainingKNIME Hub
- 01_Guided_VisualizationKNIME Hub
- Show all 179 workflows
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.