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
 All Forums
 Origin Forum
 Origin Forum
 Text/Numeric conversion

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
wilrski Posted - 04/05/2010 : 5:00:47 PM
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!
2   L A T E S T    R E P L I E S    (Newest First)
Penn Posted - 04/06/2010 : 04:06:15 AM
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
wilrski Posted - 04/05/2010 : 5:25:25 PM
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

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000