How to convert String to Number(Long)

[Maciej_Kosowski]

Hi
I have some string data like this

I have to convert them into numbers without loosing any numbers after comma and later to do some calculations. String manipulations like

toLong($2020_01$)

or string to number (long or double) node did not worked, because truncated to 3 decimal places

I would appreciate any help that helps me to convert the whole string to countable number
Thank You

[ipazin]

Hi @Maciej_Kosowski,

welcome to KNIME Community!

Long type can’t have decimal values so you definitely need to convert your strings to doubles. In KNIME data output view default is 3 decimal places but whole values is stored. You can see this if you right-click on column and choose Full Precision from available Renderers.

Br,
Ivan