Converting Double to String without Exponential "E"

[chua.rk.1]

  I'm having problem reading document numbers in Knime because the program will read it as a double since it is a very big number. How can I remove the commas in doubles?

 

[Iris]

Hi chua,

can you make me an example file, which cannot be read? Which node are you using?

Best, Iris

[RolandBurger]

Hi chua,

You can solve this by using a Round Double node instead of Number to String. Just set the precision to 0 and choose Standard String as output format.

Hope that helps!

Cheers,

Roland

[davidscarpetti]

Thanks for this! Before this I had to write my file and alter the format with an awk printf statement, ugly solution. This is great, thanks again.

Dave