The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
Username:
Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Combining data files
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

tp1978

USA
Posts

Posted - 02/21/2007 :  2:38:19 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Version 6.1
Operating System: Windows 2000

Hi,

I have 10 files, each with 10 rows and 2 columns. I need to combine all the columns in a cumulitive manner (using script). The files have generaic names: P1.txt, P2.txt, ....., P10.txt
The x-axis in the files are 0-0.1, 0.1-0.2, 0.2-0.3, ...... 0.9-1.0

So now I'm manually opening each file, copying the 10 rows and 2 columns, and adding it cumulatively to a worksheet, so that my x-axis ranges from 0.0-1.0 (spanning all the data).

I'm not sure how to use a script to generate the final worksheet right away (cumulatively added data from the 10 files, x-axis ranging from 0.1-1.0). I can open the script window (using Alt+3) but how does one write a script and run it ?

Mike Buess

USA
3037 Posts

Posted - 02/21/2007 :  11:32:49 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
There's no need for a script. Use Import > Multiple ASCII and select Import each file as: New Rows above the import list.

Mike Buess
Origin WebRing Member
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000