I’m using cell splitter with a “.” delimiter to split some barcode data. The splitter is automatically converting text values to integers. Eg., 565.001 is being split into 565 and 1, instead of 565 and 001. This happens even if I designate the source column as string.
Please see the attached workflow to reproduce the issue. I’m using the latest version of Knime: 4.6.1
Thank you for this suggestion. I was able to split them using your suggested method. Still, it feels weird that Knime would allow for data loss without an option to configure it.
Hi @kasi , I agree, it is weird, especially that the data is “lost”.
I understand that Knime wants to guess the type, but I think it might safer to put the output as String, as it’s usually no issue converting string to other types, but not the other way around.