How to convert String to Number(Long)

Hi
I have some string data like this
image
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

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.

FullPrecision

Br,
Ivan

3 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.