| Author |
 Topic  |
|
|
Aidyle
USA
Posts |
 Posted - 10/03/2006 : 3:15:53 PM
|
Origin Version (Select Help-->About Origin): Student Version 7.5
Operating System: XP
Hi,
The ASCII files that I importing as columns are sequential files containing 1 X column and 1 Y column, each file numbered 1 - whatever. However, when they have been imported into origin I am never sure what order they are in (it seems to put the last file first then maybe the rest)
Is there anyway to import the columns and maintain the file name as the column header? |
|
|
Mike Buess
USA
3037 Posts |
Posted - 10/03/2006 : 6:00:53 PM
|
It would help to know your import method... Import Multiple ASCII? File > Open? Drag and drop? custom script?
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 10/03/2006 6:05:08 PM |
 |
|
|
Aidyle
USA
Posts |
Posted - 10/04/2006 : 10:12:07 AM
|
| I am importing multiple ASCII. |
|
|
|
Mike Buess
USA
3037 Posts |
Posted - 10/04/2006 : 11:11:54 AM
|
Files are imported in the order they are listed at the bottom of the file dialog. You can sort the list alphabetically by clicking the File Name column header.
Mike Buess
Origin WebRing Member |
|
|
|
Aidyle
USA
Posts |
Posted - 10/04/2006 : 11:23:00 AM
|
Hi Mike,
Sorry but I don't think I am explaining myself properly. I am importing multiple files containing XY columns into the SAME worksheet so if I import ten files I have 20 columns in one worksheet. What I want to do is have the column heading/name the same as the file it originated from. For instance, if I import files named "A" "B" "C" into one worksheet, I have no idea which column is which (I think it imports the last file first and then the rest in sequential) - basically I lose the origin of my data |
|
|
|
Aidyle
USA
Posts |
Posted - 10/04/2006 : 1:24:03 PM
|
Hi Mike,
Sorry but I don't think I am explaining myself properly. I am importing multiple files containing XY columns into the SAME worksheet so if I import ten files I have 20 columns in one worksheet. What I want to do is have the column heading/name the same as the file it originated from. For instance, if I import files named "A" "B" "C" into one worksheet, I have no idea which column is which (I think it imports the last file first and then the rest in sequential) - basically I lose the origin of my data |
|
|
|
Mike Buess
USA
3037 Posts |
Posted - 10/04/2006 : 1:26:00 PM
|
I understand what you're doing but maintain that the Import Multiple ASCII dialog imports in the exact order the files are listed. The bottom file list in the dialog below was created by selecting "Data with Noise.dat" at the top, Shift+selecting "fftfilter2.DAT" and then clicking Add Files. In the list at the bottom the last file is indeed listed first and the rest in order. (This is standard MS dialog behavior.) Click the File Name column header in the bottom list to move fftfilter2.DAT to the end of the list where it belongs. If you still need to label the columns run this script after each import...
loop(i,1,fdlog.multiopen.count) {
ii=2*(i-1);
fdlog.get(A,i,1);
wks.col$(ii+1).label$=%A;
wks.col$(ii+2).label$=%A;
};
wks.labels();
Mike Buess
Origin WebRing Member
Edited by - Mike Buess on 10/04/2006 1:27:45 PM |
|
|
| |
Topic |
|
Importing ASCII files