Number to String

[psycho]

Hi KNIME members,

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.

I went through other similar topics but no one contained the answer I am looking for. Could somebody help me please?

[aworker]

Hi @psycho

I do not know whether there exists a node in KNIME that converts doubles to integers or longs whilst preserving the format you want. For me, “11,312,918.20” is just a possible (more human) string representation of “1.13129182E7” among many possible different ones and eventually, if no node deals with this, the following workflow may be a solution:

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

Hope it helps.

Best
Ael

[McReady]

Hi @psycho,
did you get the output within KNIME AP or did you write it to an Excel an you see it there?

[DiaAzul]

@psycho

I just created a new KNIME node which uses Python to format numbers to strings. It uses the core Python functionality, so there is no need to install any additional Python dependencies.

The node uses the Python Format Specification Mini-Language to provide maximum flexibility in formatting the output numbers.

The node is available here, and there is a demonstration workflow here.

Example formatting:
8.2f - formats the number with 8 significant digits and two decimal places.

+8.2f - as above, but adds the sign.

.0f - Floating point number with no decimal places.

,8.2f - The comma adds thousand separators.

.2% - Formats the number as percentage with two decimal places.

0>4d - Formats an integer with four digits, right aligned and pad left with zeros.

X - Format output as hexadecimal.

There are plenty more examples on the internet if you search for Python formatting digits.

DiaAzul
LinkedIn | Medium | GitHub

[ipazin]

Hello @psycho,

you can use Round Double node to convert double to String with no exponent and defined number of decimal places.

Br,
Ivan

[aworker]

Hi @ipazin

The -Round Double- node rounds at the right number of decimals and allows the direct conversion of the rounded double to a string in different formats as shown here below, but non of them add comma separators to the string.

Am I missing anything at the node configuration ? Thanks in advance for your feedback.

Best
Ael

[ipazin]

Hello @aworker,

you are not missing anything. There’s no comma as separator configuration option in this node. I just presented option to get string without exponent easily. Regarding number formatting there have been a lot of topics regarding it and believe there are one node solutions using regex (and probably couple of components) to deal with it. Here I share one:

Formatting numbers for webportal views

Hi fellows, I had quite some trouble to display numbers in the webportal in readable fashion with a thousand-seperator " , " within the “Table Editor” node. Generically, it seems that number formats don’t come with seperators (except decimal seperators, which you can easily check in the node configuration itself. Would be cool to have this feature for thousand seperators as well.) (see example screenshot 1). The number to string does not work, as a decimal seperator is set straight after the f…

Br,
Ivan

[aworker]

Hi @ipazin

Thanks for the feedback. I like your solution based on Java as suggested in your post. It is equivalent to the one by @DiaAzul but instead of being based on Python, yours is based on Java.

It would be nice to have a dedicated KNIME node to format numerical data once it is converted into strings in the way the .format() method does in Java and Python

Enjoy your day ahead!

Best
Ael

[DiaAzul]

@aworker

@aworker

It would be nice to have a dedicated KNIME node to format numerical data once it is converted into strings in the way the .format() method does in Java and Python

Unless I am missing something that is what the node I posted does. Are you saying you want a KNIME native node that does the same thing?

[aworker]

Hi @DiaAzul

Yes, this is what I said, a native node as part of the basic KNIME nodes.
I understand that your component does the job and this is great.

Best
Ael

[psycho]

aworker,

Thank you for this solution it worked. The data set that I had to work was small data set hence I tried your solution first and it worked. I will try the same solution with a large data set and will let you know the outcome. thanks again.

[aworker]

Hi @psycho

Thanks for the feedback and for validating the solution. Please let us know eventually if the solution is fast enough. Based on your feedback, an improved solution might be brought forward.

Best wishes,
Ael