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
 Wrong values after file import

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
patrick031284 Posted - 09/21/2007 : 03:34:54 AM
Origin Version (Select Help-->About Origin): OriginPro 7.5 Server
Operating System: Windows XP

Hello,

i want to import .txt-Files into my Origin. This txt-Files includes hexadecimal values in 10000 rows. But values like "0E1", "0E2", and so on were shown as "0" in the cells. I don't know what i have to change in my import assistant so that i get the correct values.

Thanks for your help!!

Kind regards
Patrick

2   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 09/25/2007 : 10:42:28 AM
Try using the Import Wizard.
When you get to the Data Columns page, right click on the column header of each column that has HEX data and choose Set Format : Text.
That should prevent Origin from attempting any numeric conversion of your data.

You can convert a column from HEX to DECIMAL with a script like this:
get col(A) -e end;
loop(ii,1,end) {
%B=col(A)[ii]$;
val=hex(%B);
col(A)[ii]=val;
}
which would convert values in column 'A' from hex to decimal.

Deanna Posted - 09/23/2007 : 10:55:34 PM
Hello Patrick,

I am sorry that Origin cannot import hexadecimal data directly. You will have to convert the data to binary or decimal and then import it into Origin.

Very sorry for the inconvenience.

Deanna
OriginLab Technical Services

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