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
 Importing Hex Issue
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

jcrespi

USA
2 Posts

Posted - 08/05/2015 :  11:51:59 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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

Castiel

343 Posts

Posted - 08/05/2015 :  12:18:47 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.

妾+   午旦  妹罕妾  妾伊    用仇  妾/     岫ㄞ
 妾京用 仍巨  件 侈   件戶' 甘岫平   /欠  白岫妹
   併             艮          岫  奈 白   岫
                              岫
Go to Top of Page

jcrespi

USA
2 Posts

Posted - 08/05/2015 :  12:56:02 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
That worked, thanks
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