| T O P I C R E V I E W |
| doncev |
Posted - 04/14/2011 : 08:17:32 AM
Origin Ver. 8 and Service Release 6 (Select Help-->About Origin):
Operating System:XP
Dear Origin,
I am having lots (thousands) of ascii data with 5 raws of header and 100 columns each and variable number of rows (around 50). Is there a fast way to merge there ascii files. Making one out of 1000 files keeping the header only at the beginning once and adding data in rows. I have tried several scripts importing data but it took always really long time. Any idea?
Thanks.
J. |
| 3 L A T E S T R E P L I E S (Newest First) |
| minimax |
Posted - 04/21/2011 : 02:56:50 AM
Hi Jelena,
The speed should have been improved in latest version (8.5.0 sr1).
We add one option "Same File Info. in Workbook" in the dialog:
By unchecking it, the import speed should be much faster.
Max
OriginLab Technical Support |
| doncev |
Posted - 04/15/2011 : 02:36:51 AM
Hi Greg,
I am aware of this method but it takes really long. Is there any thick to make it faster.
Cheers,
J |
| greg |
Posted - 04/14/2011 : 3:58:03 PM
Use the Import Wizard to create a filter to
Import Mode = Start New Rows (Source page)
Turn off all File Name Options
Set header to exclude all header and subheader
Save the filter to your User Files Folder and call it AppendRows or some such..
Now drag and drop all your files from Explorer onto Origin. If you get a message because your file extension is the same as an existing filter, choose the AppendRows filter.
For your old version, you might have to check Tools : Import Filters Manager. I forget if new filters were automatically added with drag-drop checked. They are in 8.5. |
