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 |