String to Number problem

Hi,

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 

5.7694719999999997E23

		<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>
		</td>
	</tr>
</tbody>

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.

Cheers,

Roland

1 Like