| T O P I C R E V I E W |
| Tk1544 |
Posted - 01/11/2019 : 05:22:58 AM
Hey,
I am using Origin 8.5.1 and have a problem with importing my ASCII files to Origin.
I have around 150 ASCII data files. In each file the data is seperated by spaces (with 9 of header lines on top).
If I just import one ASCII file (Import Assistant)it works out fine. BUT each "number" is in one column. I just want them in one column under each other. So I found the function Worksheet > "Transpose" where I can fix that - so all "numbers" are then under each other in one column.
I attached a picture to better illustrate my problem. Or see here: https://ibb.co/JsWnhRD
The problem is that I have 150 ASCII files and I don't want to do that manually. Is there a solution to fix the import and transpose in one - so that I receive 150 columns in the end with all my data in one project? [I tried the import "many ASCII files" function but its only replacing each ASCII file and doesn't import all]
It would be really nice if you could help me out with this problem (I guess I have to write a program - but I never programmed in my life, so it might be a problem for me)
Thanks
Tk1544
**In addition: I thought about open all 150 ASCII files with the "import assistant" so I ll receive 150 "Books". So I ll need a short command on Labtalk to take always the first line of one book, copy it to an empty book and transpone it to a column.
The problem is that I never programmed and so I don't know how to write a file like that** |
| 1 L A T E S T R E P L I E S (Newest First) |
| YimingChen |
Posted - 01/11/2019 : 11:50:11 AM
Hi,
Here's one thought, in Import Multiple ASCII setting dialog, under Import Options node, set Multi-File Import Mode to Start New Rows. This way, once all your files are imported, they are stacking row-wise. Then do a transpose on the worksheet to get want you expect. See if it works. Thank you.
James |
|
|
