Converting Double to String without Exponential "E"

  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?

 

2 Likes

Hi chua,

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

Best, Iris

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

6 Likes

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

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