Icon

kn_​forum_​45693_​column_​expression_​replace_​comma

switch dot and comma in string column - and remove special characters
switch dot and comma in string column - and remove special charactersreplaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","") 682.500,00"682.500,39"replaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","")682500.0682500.39 Table Creator Column Expressions String To Number switch dot and comma in string column - and remove special charactersreplaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","") 682.500,00"682.500,39"replaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","")682500.0682500.39 Table Creator Column Expressions String To Number

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-08-04
On NodePit since: 2022-08-04
Last update: 2024-04-27
Created with KNIME version: v4.6.1
Tags: dotcommaswitchnumberconvertcolumnexpression

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

Try NodePit Runner!