topic Re: 1E+05 to 100000 in Discussions

1E+05 to 100000

almighty22 — Wed, 04 Sep 2019 03:24:37 GMT

Hi guys,

Why the JSL didn't change the 1E+05 to 100000 when I tabulate the data? What can I do?

Re: 1E+05 to 100000

almighty22 — Wed, 04 Sep 2019 03:27:10 GMT

And also the graph that I stimulate. Showing only the front number like 1.01E+05 from my raw data and it shown directly at the graph axis as 1.01E+05.

Re: 1E+05 to 100000

txnelson — Wed, 04 Sep 2019 04:22:28 GMT

You may have to provide your data table and/or script to allow the determination of your issue. But I will guess that it may be because you are specifying a Scientific format for the data in your data table.

Re: 1E+05 to 100000

almighty22 — Wed, 04 Sep 2019 06:17:16 GMT

Thanks nelson. You remind me, is the scientific format issues. I fixed it.

Re: 1E+05 to 100000

txnelson — Wed, 04 Sep 2019 06:31:59 GMT

The issue is that the data in scientific notation, coming from the .txt files is being interpreted by JMP as character data, not numeric. I am not aware of a method to change that during the reading in of the data, however, it is a simple matter to do that after the data are in the data table. The following modification to your code will make the changes:

:Column 1 << Set Name( "Frequency" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 2 << Set Name( "S11 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 3 << Set Name( "Result1" );
:Column 4 << Set Name( "S21 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 5 << Set Name( "Result2" );
:Column 6 << Set Name( "S22 Data" )<<data type(numeric)<<modeling type(continuous)<<format("Best",15,7);
:Column 7 << Set Name( "Result3" );

Please note the format setting. You can change the format to any JMP numeric format, and it will that format the Graph windows will use.