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
- String Manipulation8 %
Row Filter (deprecated)6 %- Rule Engine5 %
- Column Filter5 %
- Excel Reader5 %
Column Rename4 %- GroupBy4 %
- Number to String4 %
- Joiner4 %
- CSV Reader4 %
- Rule-based Row Filter3 %
- String to Date&Time2 %
- Concatenate2 %
- String to Number2 %
- Missing Value2 %
- String Replacer2 %
- String Manipulation (Multi Column)2 %
- Column Expressions2 %
- Column Resorter2 %
- Duplicate Row Filter1 %
- Constant Value Column1 %
- Math Formula1 %
- Column Renamer< 1 %
- Cell Splitter< 1 %
- Rule-based Row Splitter< 1 %
- File Reader< 1 %
- Column Auto Type Cast< 1 %
Row Splitter (deprecated)< 1 %- Table Creator< 1 %
- Sorter< 1 %
- Date&Time to String< 1 %
- DB Reader< 1 %
- Nominal Value Row Filter< 1 %
- DB Query Reader< 1 %
- Column Merger< 1 %
- Number Rounder< 1 %
- Pivot< 1 %
- Reference Row Filter< 1 %
Column Appender< 1 %- Loop End< 1 %
- Column Combiner< 1 %
- Cell Splitter By Position< 1 %
- RowID< 1 %
- Date&Time-based Row Filter< 1 %
- Table Manipulator< 1 %
- Google Sheets Reader< 1 %
- Unpivot< 1 %
- Date&Time Difference< 1 %
- Column Renamer (Dictionary)< 1 %
- Date&Time Part Extractor< 1 %
Joiner< 1 %- Partitioning< 1 %
- Parquet Reader< 1 %
- Column Aggregator< 1 %
- Ungroup< 1 %
- Missing Value Column Filter< 1 %
- Table Transposer< 1 %
- Value Lookup< 1 %
- Numeric Binner< 1 %
- Cross Joiner< 1 %
- String Splitter (Regex)< 1 %
- Column Appender< 1 %
- Row Filter (Labs)< 1 %
- String to Number (PMML)< 1 %
- Java Snippet< 1 %
- Lag Column< 1 %
Excel Reader (XLS)< 1 %- Column Rename (Regex)< 1 %
- Row Sampling< 1 %
- Column Splitter< 1 %
String Replace (Dictionary)< 1 %- Excel Writer< 1 %
- Decision Tree Predictor< 1 %
- Category to Number< 1 %
- SMOTE< 1 %
Cell Replacer< 1 %- Nominal Value Row Splitter< 1 %
- Normalizer< 1 %
- Table Reader< 1 %
- String Replacer (Dictionary)< 1 %
- Auto-Binner< 1 %
- One to Many< 1 %
- Math Formula (Multi Column)< 1 %
- String to Date/Time (legacy)< 1 %
- Number to String (PMML)< 1 %
- Modify Time< 1 %
- Table Column to Variable< 1 %
Table Reader< 1 %- Double to Integer< 1 %
- Group Loop Start< 1 %
- XPath< 1 %
- Reference Column Filter< 1 %
- Statistics< 1 %
- Box Plot (legacy)< 1 %
- JSON to Table< 1 %
- Filter Apply< 1 %
- Denormalizer (PMML)< 1 %
- Variable to Table Column< 1 %
Variable to Table Column< 1 %- Line Plot (Plotly)< 1 %
- Table View (JavaScript)< 1 %
- File Reader (Complex Format)< 1 %
- Loop End (Column Append)< 1 %
Excel Reader (XLS)< 1 %- Table Difference Finder< 1 %
- Rank< 1 %
- DB Insert< 1 %
- PMML Predictor< 1 %
- Scatter Plot (JavaScript)< 1 %
- Moving Aggregator< 1 %
- Create Collection Column< 1 %
- IF Switch< 1 %
- Extract Table Spec< 1 %
- Date&Time Shift< 1 %
- SVM Predictor< 1 %
- Case Converter< 1 %
- Rule Engine (Dictionary)< 1 %
- Nominal Row Filter Configuration< 1 %
- Column Filter (legacy)< 1 %
Python Script (1⇒1)< 1 %- CSV Writer< 1 %
- Perl Scripting< 1 %
Loop End (2 ports)< 1 %- Column Comparator< 1 %
Linear Correlation< 1 %- Table Validator< 1 %
- Reference Row Splitter< 1 %
- End IF< 1 %
- Timer Info< 1 %
- Parameterized DB Query Reader< 1 %
Excel Writer (XLS)< 1 %- Top k Row Filter< 1 %
- Path to String< 1 %
- Row to Column Names< 1 %
- Try (Data Ports)< 1 %
Database Looping< 1 %- Random Forest Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Correlation Filter< 1 %
- String Manipulation (Variable)< 1 %
- Empty Table Switch< 1 %
- String to Duration< 1 %
- XGBoost Predictor< 1 %
- Read Excel Sheet Names< 1 %
- Capture Workflow End< 1 %
- SharePoint Online List Reader< 1 %
Variable to Table Row< 1 %CSV Reader< 1 %- Chunk Loop Start< 1 %
- Naive Bayes Predictor< 1 %
- Association Rule Learner< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Domain Calculator< 1 %
- Denormalizer< 1 %
- Numeric Row Splitter< 1 %
- Numeric Outliers< 1 %
- DB Writer< 1 %
- H2O to Table< 1 %
- Document Data Extractor< 1 %
- Shapley Values Loop End< 1 %
- Date Field Extractor (legacy)< 1 %
- RDKit From Molecule< 1 %
Regex Extractor< 1 %- Run Heavy Garbage Collector< 1 %
- Table Row to Variable Loop Start< 1 %
- Filter Apply Row Splitter< 1 %
- Merge Variables< 1 %
- Scorer (JavaScript)< 1 %
- Refresh Button Widget< 1 %
- Python Script (legacy)< 1 %
- Date Extractor< 1 %
- Dose Response (R)< 1 %
- Split Collection Column< 1 %
- Delete Files (legacy)< 1 %
- Catch Errors (Data Ports)< 1 %
Database Connection Table Reader< 1 %File Reader< 1 %- k-Means< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Column Name Extractor< 1 %
- Missing Value (Apply)< 1 %
- Data Explorer< 1 %
- Crosstab< 1 %
- Parallel Chunk End< 1 %
- Counter Generation< 1 %
- Term to String< 1 %
- Weka Predictor (3.7)< 1 %
- Double Configuration< 1 %
- String Configuration< 1 %
- JSON Path< 1 %
- R Snippet< 1 %
- Scorer< 1 %
- Numeric Scorer< 1 %
- Rank Correlation< 1 %
- Double Input (legacy)< 1 %
- RDKit To Molecule< 1 %
- Latitude/Longitude to Coordinate< 1 %
- CASE Switch End< 1 %
- Regex Extractor< 1 %
- CASE Switch Start< 1 %
- File Download (legacy)< 1 %
- Data to Report (BIRT)< 1 %
- Table Cropper< 1 %
IF Switch (Flow Variable Value)< 1 %- Shapefile Point Reader< 1 %
- Number Formatter< 1 %
- Strings to Binary Objects< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Variable to Table Row< 1 %- ARFF Reader< 1 %
Database Reader< 1 %Simple File Reader< 1 %- Fixed Width File Reader< 1 %
Loop End< 1 %- Column List Loop Start< 1 %
Generic Loop Start< 1 %Recursive Loop End< 1 %- X-Aggregator< 1 %
- X-Partitioner< 1 %
- K Nearest Neighbor< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Linear Regression Learner< 1 %
- Logistic Regression Predictor< 1 %
- Regression Predictor< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Learner< 1 %
- Add Empty Rows< 1 %
- Binner (Dictionary)< 1 %
- Category to Number (Apply)< 1 %
- Linear Correlation< 1 %
- Create Table Structure< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Constant Value Column Filter< 1 %
- Low Variance Filter< 1 %
- Normalizer (PMML)< 1 %
- Shuffle< 1 %
- Value Counter< 1 %
CASE Switch Data (Start)< 1 %- Conditional Box Plot (legacy)< 1 %
- Color Manager< 1 %
- SDF Reader< 1 %
- DB GroupBy< 1 %
- One Row to Many< 1 %
- Math Formula (Variable)< 1 %
- Java Snippet (simple)< 1 %
- List Box Configuration< 1 %
- Value Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- Line Plot (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Container Input (Table)< 1 %
- Python Source (legacy)< 1 %
- Duration to Number< 1 %
- Legacy Date&Time to Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Modify Date< 1 %
- Remove Empty Rows< 1 %
- Molecular Properties< 1 %
- RDKit Descriptor Calculation< 1 %
- Wait...< 1 %
- Table Row to Variable< 1 %
- Variable to Table Row< 1 %
- Variable Loop End< 1 %
- PNN Predictor< 1 %
- Logistic Regression Learner< 1 %
- Many to One< 1 %
- Table Validator (Reference)< 1 %
- Row Splitter (Labs)< 1 %
- Normalizer (Apply)< 1 %
- Reference Column Resorter< 1 %
- DB Connection Closer< 1 %
- Empty Table Creator< 1 %
- Keras Network Executor< 1 %
- Variable Expressions< 1 %
- LIBSVMPredictor< 1 %
- Replacer< 1 %
- String to Path< 1 %
- Column Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- Column Selection Configuration< 1 %
- Column Selection (legacy)< 1 %
- Fingerprint Similarity< 1 %
- Variable Creator< 1 %
- Interactive Value Filter Widget< 1 %
- Trim Table< 1 %
- Table Splitter< 1 %
- Salesforce Simple Query< 1 %
- URL to File Path< 1 %
Table Column to Variable< 1 %Extract Context Properties< 1 %Recursive Loop End (2 ports)< 1 %- Auto-Binner (Apply)< 1 %
- Column to Grid< 1 %
- Rule Engine Variable< 1 %
- Cache< 1 %
- Load Layout< 1 %
- Copy/Move Files (legacy)< 1 %
Counting Loop Start< 1 %- Hierarchical Clustering< 1 %
- Number to Category (Apply)< 1 %
Parquet Reader< 1 %- Association Rule Learner (Borgelt)< 1 %
- Extract Attribute< 1 %
- R Snippet (2:1)< 1 %
- Breakpoint< 1 %
Table Column to Variable< 1 %- Shape Manager< 1 %
- Similarity Search< 1 %
- OpenBabel< 1 %
- Strings to Document< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- File Chooser Widget< 1 %
- String Widget< 1 %
JSON Reader< 1 %Python Script (1⇒2)< 1 %Python Script (2⇒1)< 1 %- Date&Time to legacy Date&Time< 1 %
- Modify Time Zone< 1 %
- Time to String (legacy)< 1 %
- Hierarchical Anonymization< 1 %
- Multiport Loop End< 1 %
- Fuzzy Rule Predictor< 1 %
CASE Switch Variable (Start)< 1 %- Molecule Type Cast< 1 %
- Index Query< 1 %
- Container Input (Row)< 1 %
Column Distance< 1 %- Find Elements< 1 %
Flow Variable IF Switch< 1 %Variable to Table Column< 1 %- Inject Variables (Data)< 1 %
List Files< 1 %Recursive Loop Start< 1 %Variable Loop End< 1 %Scorer< 1 %- SOTA Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Create Bit Vector< 1 %
- Edit Nominal Domain< 1 %
- Linear Discriminant Analysis Compute< 1 %
CASE Switch Data (End)< 1 %- ROC Curve (legacy)< 1 %
Parquet Reader< 1 %- Random Number Assigner< 1 %
- H2O Numeric Scorer< 1 %
- Punctuation Erasure< 1 %
- Single Selection (legacy)< 1 %
- Image Converter< 1 %
- Image Cropper< 1 %
- Image Normalizer< 1 %
- R to Table< 1 %
- Moving Average< 1 %
- Web Log Reader< 1 %
Extract Attribute< 1 %Table Extractor< 1 %- Type< 1 %
- Benchmark Start< 1 %
- PCA< 1 %
- Bootstrap Sampling< 1 %
- Spark to Table< 1 %
- Random Matcher< 1 %
- Java IF (Table)< 1 %
- Integer Configuration< 1 %
- Container Output (Table)< 1 %
- Don't Save Start< 1 %
- R View (Table)< 1 %
SAP Reader (Theobald Software)< 1 %- Hierarchy Reader< 1 %
- Anonymization< 1 %
- XLS Control Table Generator< 1 %
- Fingerprint to String< 1 %
- Shapefile Polygon Reader< 1 %
- Plate Row Converter< 1 %
- Expand Well Position< 1 %
- MolConverter< 1 %
- Fingerprints Expander< 1 %
- Binary Objects to Strings< 1 %
- String to URI< 1 %
- Unzip Files (legacy)< 1 %
- URI to String< 1 %
- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Database Delete< 1 %Line Reader< 1 %- Feature Selection Filter< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Interval Loop Start< 1 %- Polynomial Regression Learner< 1 %
Concatenate (Optional in)< 1 %- HiLite Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- Column Filter (PMML)< 1 %
- One to Many (PMML)< 1 %
- Target Shuffling< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Extract Table Dimension< 1 %
- Data Generator< 1 %
- Save Workflow< 1 %
ORC Reader< 1 %- SDF Stripper< 1 %
- Random Label Assigner< 1 %
- Random Item Inserter< 1 %
- Prediction Fusion< 1 %
- SAS7BDAT Reader< 1 %
Read Excel Sheet Names (XLS)< 1 %- Java Snippet Row Filter< 1 %
- Tika Parser< 1 %
- Meta Info Extractor< 1 %
- String to Term< 1 %
- Google Analytics Query (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Nominal Row Filter Widget< 1 %
- Multiple Selection Widget< 1 %
- Single Selection Widget< 1 %
- String to JSON< 1 %
- Network Analyzer< 1 %
- R Source (Table)< 1 %
- GET Request< 1 %
- Duration to String< 1 %
- Extract Duration Fields< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- RDKit Canon SMILES< 1 %
- RDKit Fingerprint< 1 %
- Indigo Fingerprint< 1 %
- Fingerprint From Hexadecimal String< 1 %
- Generic Run-to-time Loop Start< 1 %
- Collection to String< 1 %
- Range Filter< 1 %
- MzTabReader< 1 %
- Molecular Surface Area< 1 %
- Fuzzy c-Means< 1 %
- Decision Tree to Image< 1 %
- MDS (DistMatrix)< 1 %
- PCA Apply< 1 %
- PMML Gradient Boosted Trees Predictor< 1 %
- Tree Ensemble Learner< 1 %
- String to SVG< 1 %
- Edit Numeric Domain< 1 %
- Set Operator< 1 %
- Renderer to Image< 1 %
- DB Joiner< 1 %
- DB Table Remover< 1 %
- Radar Plot (Plotly)< 1 %
- Generic Web Service Client< 1 %
- Geo-Coordinate Row Filter< 1 %
- Category to Class< 1 %
- Diacritic Remover< 1 %
- Create Folder< 1 %
- List Files/Folders< 1 %
- Files/Folders Meta Info< 1 %
- Boolean Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Integer Widget< 1 %
- Value Selection Widget< 1 %
- Columns to JSON< 1 %
- Image Properties< 1 %
- Image Resizer< 1 %
- Parameter Optimization Loop End< 1 %
- Extract Time Window (legacy)< 1 %
- Byte Converter< 1 %
- Quit WebDriver< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
- [ISPRENL S11] Group 5 MCO2 WorkflowKNIME Hub
- [Latest] Consolidated 3 Mar 1210KNIME Hub
- [ON] PEX ROTINAS 2024KNIME Hub
- Show all 2046 workflows
Links
- Conversion from Unix timestamp to Dateby qqilihq on 2020-03-12forum.knime.com/p/84243
- Formatting negative values on the rightby armingrudd on 2020-02-20forum.knime.com/p/82178
- column expressionby armingrudd on 2019-12-08forum.knime.com/p/76444
- Error String to Numberby qqilihq on 2020-12-03forum.knime.com/p/109926
- How to int() in a math nodeby armingrudd on 2019-09-16forum.knime.com/p/70155
- Show all 6 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.