The Origin Forum - multi import into rows

The Origin Forum

Username:	Password:
Save Password
Forgot your Password? \| Admin Options

All Forums

Origin Forum for Programming

LabTalk Forum

multi import into rows

New Topic

Reply to Topic

Printer Friendly

Author

Topic

msacher

Germany
Posts

Posted - 02/01/2006 : 01:26:08 AM

Hi,

I want to use the LabTalk multiple import function (getfile -m *.*;). The selected files shall be imported into one wks. The datasets must be one BELOW the other (new rows and NOT into new columns). Furthermore the first 37 rows of each file must be ignored, because they include header information.

This task seems to be very easy, but I have no idea, how to solve / program it.

I hope, someone has an idea.
Thank you
Marc

Mike Buess

USA
3037 Posts

Posted - 02/01/2006 : 07:51:46 AM

Hi Marc,

The first step is to prepare the worksheet's ASCII Options...

1. Open a new worksheet from the main toolbar.
2. Select File > Import > ASCII Options
3. In the File Header section at bottom set Skip main header... value to 37.
4. Select Import Into Worksheet as New Rows.
5. Select any other options that seem appropriate.
6. Click the Update Options button.
7. Click the Save Template button on the main toolbar.
8. Test it out by importing from the File > Import menu and adjust your ASCII Options as needed for proper results.

If you search this forum you'll find many scripts for multiple-file importing with LabTalk so I'll just give you a simple example that uses getfile -m and the template you just prepared...

getfile -m *.*; // open multiple-file dialog
if(count==0) return; // quit if cancelled
win -t Data; // open a worksheet from your default template
for(ii=1;ii<=count;ii++) {
getfile -g ii; // %A = iith file path\name
open -w %A; // import to active worksheet
};

Mike Buess
Origin WebRing Member

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

The Origin Forum

Snitz Forums 2000