String to Number problem


When I try to read the read content of the attached file with file reader and change the content to number using string to number (decimal) then the number changes to 


		<p>which is different than the original number. We have many similar numbers in the original file, and there is no problem with them, but this specific number lose its precision. I thought this might be a bug, or am I missing something here?</p>

		<p>Any guidance would high be appreciated.</p>

		<p>Best Regards</p>

Hi Ertan,

The problem here is that accurate representation of this number requires a precision that is beyond the standard double-precision floating point format that is used in KNIME. At present, greater precision is not supported in KNIME.



1 Like