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.

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.
Output Ports
0 Input data with new DoubleTypes.
This node is contained in KNIME Base Nodes provided by KNIME GmbH, Konstanz, Germany.