| T O P I C R E V I E W |
| The_Arctic |
Posted - 06/28/2018 : 3:56:09 PM
Origin Ver. and Service Release: OriginPro 8 SR0
Operating System:Windows 10
Hi
i'm having troubles converting data, which is imported from an ASCII file as a text string (-4.018596219679p, for example), to a number (which would be -4.018596219679E-12 in that case ), in order to make a graph.
In origin 6, the only step needed was to change the column format from "text and numeric" to "numeric", however this is no longer the case, all i get is cells filled with "--".
i'd like to know the easiest non-manual way to execute that.
Thanks in advance.
|
| 4 L A T E S T R E P L I E S (Newest First) |
| Mike |
Posted - 03/26/2019 : 5:23:58 PM
There is actually a LabTalk system variable, introduced in version 7, that I think would have saved The_Artic.
1. Click Window: Script Window, enter the following at the prompt and press Enter:
@EF=1
This forces a Text & Numeric column (Origin's default) to treat engineering notation entered directly, as a numeric.
Note that Origin 2019 and later you simply change column format (https://www.originlab.com/doc/Origin-Help/ColProperties-Dialog-Properties-Tab) from Text & Numeric to Numeric-- no change to system variables needed.
Mike Genthner
OriginLab Tech Support |
| cpyang |
Posted - 06/29/2018 : 2:09:25 PM
You are asking about a piece of software made more then 20 years ago, so I doubt anyone still remember anything specific.
Why not just import data in Origin 6, save the file, and open and use in later version?
CP
|
| The_Arctic |
Posted - 06/28/2018 : 11:52:31 PM
Thanks for the answer, but just to be sure, you're telling me it isn't possible at all in origin pro 8, so i'll have to go back to origin 6 if i want to be able to work with my data if i'm not iterested in the beta?
If so, is there anything similar to a colswap or colmove function in origin 6? I couldn't find a way to make that one work. |
| cpyang |
Posted - 06/28/2018 : 8:13:41 PM
It will work like you said in the upcoming version 2019 planned for late Oct 2018 release. This has to do with automatically checking engineering units when converting Text Numeric column to numeric column.
Please contact Originlab if you are interested in a beta version.
CP
|
|
|
