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.
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.
Wrong values after file import
Posted - 09/21/2007 : 03:34:54 AM
