20230112 Pikairos Convert Double to Integer in String Format with Comma and Decimal Separators

0 ×

This workflow converts a DOUBLE number to a STRING representation with comma and decimal separator.
For instance, double number 1.13129182E7 is converted to 11,312,918.20.

This workflow is a possible solution to the question number 59243 asked by psycho at the KNIME forum:

I tried to convert 11,312,918.2 into a string but I get this 1.13129182E7 as the output which is incorrect.
My requirement is add 2 decimal places in to this number 11,312,918.2 where answer should be 11,312,918.20.

Nodes

• String Manipulation2 ×
• Cell Splitter By Position1 ×
• Interactive Table1 ×
• Math Formula1 ×
• Table Creator1 ×

Extensions

• FeatureKNIME Base nodes
• FeatureKNIME Javasnippet
• FeatureKNIME Math Expression (JEP)

Links

• Number to String

  forum.knime.com/t/number-to-string/59243