The following node is available in the Open Source KNIME predictive analytics and data mining platform version 2.7.1. Discover over 1000 other nodes, as well as enterprise functionality at http://knime.com.

String To Number

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.
If the optional PMML inport is connected and contains preprocessing operations in the TransformationDictionary the conversion operations of this node are appended.

Dialog Options

Type
Choose the DataType that your string should be converted to.
Decimal Separator
Choose a decimal separator, which is used to mark the boundary between the integral and the fractional parts of the decimal string.
Thousands Separator
Choose a thousands separator used in the decimal string to group together three digits.
Column Selection
Move the columns of interest into the "Include" list

Ports

Input Ports
0 Arbitrary input data.
1 Optional PMML document to add the preprocessing operations to.
Output Ports
0 Input data with new DoubleTypes.
1 PMML port object that includes the performed operations.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.