Issue dealing with char to num

[#1]

Hi Everyone
I am manipulating data, long strings of numbers stored as characters. I was able to break them down to the single numbers in their own column but something I cannot fix is happening.
Some numbers remain the same others are changing. An example of change is -8.7 turning into -8.6999999999999992894572642, this is screwing up the calculation and the comparison down the line. Round did not work.

Fact is when I save the data in CSV or TXT, these numbers are like they should be but when I am importing the file, the numbers in the table are ruined, This means JMP is doing something "wrong" by default.

Any idea how to fix that?

Thanks

[#2]

Most likely issue with Floating Point Math (https://0.30000000000000004.com/) .

To what are you importing the files to and from where (which file type)?

[#3 · Accepted solution]

@jthi What a great web site name! I hesitated to click when I saw it, but...perfect.

https://community.jmp.com/t5/Discussions/Condition-error/m-p/474116/highlight/true#M71894

https://community.jmp.com/t5/JSL-Cookbook-Archived/Loops/ta-p/50949

https://en.wikipedia.org/wiki/Double-precision_floating-point_format

https://community.jmp.com/t5/Discussions/Using-quot-If-quot-formula-sometimes-returns-blank-cells/m-...

[#4]

I think I got the .... point. :)) .

That so the script needs to structured in a different way.
Ty

[#5]

It is a csv but it happens with txt too.