Icon

kn_​forum_​44090_​decimal_​separator_​two_​different

column with mixed decimal separators
column with mixed decimal separators 180182,369125.654186163,3691485.654Top port = . point as decimal separator$column1$ LIKE "*.*" => TRUETRUE => FALSE. point, commaNode 5column1_numberresultreplaceChars($column1$,"," ,"." ). pointcolumn1_numberresult Table Creator Rule-basedRow Splitter String ToNumber (PMML) String ToNumber (PMML) Concatenate Column Rename Joiner String Manipulation String ToNumber (PMML) Column Rename Joiner column with mixed decimal separators 180182,369125.654186163,3691485.654Top port = . point as decimal separator$column1$ LIKE "*.*" => TRUETRUE => FALSE. point, commaNode 5column1_numberresultreplaceChars($column1$,"," ,"." ). pointcolumn1_numberresultTable Creator Rule-basedRow Splitter String ToNumber (PMML) String ToNumber (PMML) Concatenate Column Rename Joiner String Manipulation String ToNumber (PMML) Column Rename Joiner

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2022-06-13
On NodePit since: 2022-06-14
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: decimalseparator

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!