https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662815#M85156 <P>Hi Everyone<BR />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.<BR />Some numbers remain the same others are changing. An example of change is&nbsp;-8.7 turning into&nbsp;-8.6999999999999992894572642, this is screwing up the calculation and the comparison down the line. Round did not work.</P><P>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.</P><P>Any idea how to fix that?</P><P>Thanks</P> Thu, 27 Jul 2023 07:01:16 GMT Miof 2023-07-27T07:01:16Z https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662815#M85156 <P>Hi Everyone<BR />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.<BR />Some numbers remain the same others are changing. An example of change is&nbsp;-8.7 turning into&nbsp;-8.6999999999999992894572642, this is screwing up the calculation and the comparison down the line. Round did not work.</P><P>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.</P><P>Any idea how to fix that?</P><P>Thanks</P> Thu, 27 Jul 2023 07:01:16 GMT https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662815#M85156 Miof 2023-07-27T07:01:16Z https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662824#M85157 <P>Most likely issue with <A href="https://0.30000000000000004.com/" target="_blank" rel="noopener">Floating Point Math (https://0.30000000000000004.com/)</A> .</P> <P>&nbsp;</P> <P>To what are you importing the files to and from where (which file type)?</P> Thu, 27 Jul 2023 17:53:36 GMT https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662824#M85157 jthi 2023-07-27T17:53:36Z https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662967#M85165 <P><a href="https://community.jmp.com/t5/user/viewprofilepage/user-id/14366">@jthi</a>&nbsp;What a great web site name! I hesitated to click when I saw it, but...perfect.</P> <P>&nbsp;</P> <P><A href="https://community.jmp.com/t5/Discussions/Condition-error/m-p/474116/highlight/true#M71894" target="_blank">https://community.jmp.com/t5/Discussions/Condition-error/m-p/474116/highlight/true#M71894</A></P> <P><A href="https://community.jmp.com/t5/JSL-Cookbook-Archived/Loops/ta-p/50949" target="_blank">https://community.jmp.com/t5/JSL-Cookbook-Archived/Loops/ta-p/50949</A></P> <P><A href="https://en.wikipedia.org/wiki/Double-precision_floating-point_format" target="_blank">https://en.wikipedia.org/wiki/Double-precision_floating-point_format</A></P> <P><A href="https://community.jmp.com/t5/Discussions/Using-quot-If-quot-formula-sometimes-returns-blank-cells/m-p/46789/highlight/true#M26653" target="_blank">https://community.jmp.com/t5/Discussions/Using-quot-If-quot-formula-sometimes-returns-blank-cells/m-p/46789/highlight/true#M26653</A></P> <P>&nbsp;</P> Thu, 27 Jul 2023 14:01:14 GMT https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/662967#M85165 Craige_Hales 2023-07-27T14:01:14Z https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/663002#M85171 <P>It is a csv but it happens with txt too.</P> Thu, 27 Jul 2023 15:45:00 GMT https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/663002#M85171 Miof 2023-07-27T15:45:00Z https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/663112#M85186 <P>I think I got the .... point. :)) .</P><P>That so the script needs to structured in a different way.<BR />Ty</P> Thu, 27 Jul 2023 21:00:12 GMT https://community.jmp.com/t5/Discussions/Issue-dealing-with-char-to-num/m-p/663112#M85186 Miof 2023-07-27T21:00:12Z