How to add comma in specific place ?

[iChiban]

Hi.

I have a table with a column that looks like this:

3455
290
55500
1201
100

I need to add comma on the 2 place counting from right to make the table look like this:

34,55
2,90
555,00
12,01
1,00

Any suggestions which node to use?

[gonhaddock]

Hello @iChiban and welcome to the KNIME forum
‘Math Formula’ node:

$number$ * 1E-2

Or do you want to keep as text with the trailing zeros ?

‘String Manipulation’ node:

join(
	substr($number$, 0, length($number$)-2)
	, ","
	, substr($number$, length($number$)-2, length($number$))
	)

BR

[iChiban]

@gonhaddock

$number$ * 1E-2

Thank you very much that exactly what I was trying to do.