Remove invisible decimals

[ZahinOsman]

Hi guys,

I'm having an issue with some data that is run through a workflow; 

Apple 1	Apple 2
2300.45677	2300.45677	FALSE

Apple 1 results are run through a workflow. When comparing with Apple 2 results (manually inputted) using a sanity check "Apple 1 = Apple 2", it comes back as FALSE.

There are no trailing white spaces and display is showing all decimal places. I have read online it might be due to trailing floating decimal points eg. 0.000000001. How do I get rid of this, so Apple 1 = Apple 2?

Pls note the file type is .csv

[alexnajm]

Rounding should work (after converting the values to numeric) - Round([Field], 0.00001)