Change a csv to XLsx

[mlauber71]

@Asensio_Dias you can switch . (dot) and , (comma) with knime nodes. If you have to change them you might have to use an ‘intermediate’ placeholder to not confuse the system.

replace the delimiters

@Subramanyam you could use the Column Expressions. I assume you would want to do something like switch the dot and comma (otherwise you would have both separators as dots - you can of course also do this). replaceChars(replaceChars(replaceChars(replaceChars(column("column1"),"," ,"#" ),".",","),"#","."),"\"","") Two things to note use an intermediate like hash to help the switch escape the quotation mark if you want to replace it [image]