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
 Importing Hex Issue

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
jcrespi Posted - 08/05/2015 : 11:51:59 AM
Hello,

I am having trouble importing hex data into Origin 15 properly. I am able to import the data and then convert it to decimal but for hex values like "75E4" Origin outsmarts itself and decides to interpret that value as 750000 so when I convert it to decimal I get the improper value.

I have so far been unable to find a way to let Origin know during the import that the data is hex and I cannot find a way to reliably stop origin from reading the hex as scientific notation.

If any of you have any insight it would be greatly appreciated.

Thank
John
2   L A T E S T    R E P L I E S    (Newest First)
jcrespi Posted - 08/05/2015 : 12:56:02 PM
That worked, thanks
Castiel Posted - 08/05/2015 : 12:18:47 PM
quote:
Originally posted by jcrespi

Hello,

I am having trouble importing hex data into Origin 15 properly. I am able to import the data and then convert it to decimal but for hex values like "75E4" Origin outsmarts itself and decides to interpret that value as 750000 so when I convert it to decimal I get the improper value.

I have so far been unable to find a way to let Origin know during the import that the data is hex and I cannot find a way to reliably stop origin from reading the hex as scientific notation.

If any of you have any insight it would be greatly appreciated.

Thank
John


Say, there are 10 columns of data.
1. Prepare the 10 columns in Text format (Double click the column to open column properties dialog...)
2. Ctrl+k, DO REMEMBER TO CHECK THE "SHOW OPTIONS DIALOG"
3. Check the Import Options -> Miscellaneous -> Keep Target Column Format
4. Use hex2dec() to convert these columns of data.

©c¡Ï   ¤È¥¹  ©f¨u©c  ©c¥ì    ¥Î¤³  ©c/     ©¦£¯
 ©c¨Ê¥Î ¤´¥¨  ¥ó ¨×   ¥ó¤á' ¥Ì©¦¥­   /¤í  ¥Õ©¦©f
   ¨Ö             ¦á          ©¦£þ  ©` ¥Õ   ©¦
                              ©¦

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