The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Text/Numeric conversion
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

wilrski

Posts

Posted - 04/05/2010 :  5:00:47 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Hello: Very simple question, so it seems. The Origin Pro8 version is giving me a hard time converting text/numeric data into scientific notation. For example, my imported ASCII files are labeled with the appropriate numerical lettering (n=nano, p=pico, f=femto) after the numerical value. However, I cannot get the values to convert to scientific notation for further graphing purposes.

i.e. value = -1.2555n; i want to have this cell read = -1.2555e-9.

The previous version required me to convert the column to, engineering, then convert to numerical, then convert to scientific. This process gave me the correct notation and value for further use.

Any help would be appreciated. I am sure it is something simple, but I have tried multiple ways to get this to work, and it seems it does not like the letter designation along with the number value when converting.

thanks much. cheers!

wilrski

Posts

Posted - 04/05/2010 :  5:25:25 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I should specify, this only happens when the IMPORTED or typed values are FIRST in ENGINEERING notation (ie. -1.222n). Getting the values to convert to scientific notation is where the problem occurs. However, the opposite seems to convert (Scientific notation-->Engineering), without a problem.

Any help is appreciated. thanks
Go to Top of Page

Penn

China
644 Posts

Posted - 04/06/2010 :  04:06:15 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

I have tried this in all versions of OriginPro 8 (from SR0 to SR6), and find that only SR5 and SR6 can get the result you want. If you are not using SR5 or SR6, please update to SR6 according to this page, and then have a try again.

Penn
OriginLab Technical Services
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000