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
 importing data files into one		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ringman7677

USA
16 Posts
Posted - 01/15/2004 :  3:33:59 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
I have ten (10 or more) separate ASCII data files that I want to merge into one worksheet (new rows). The trick is I need to adjust the first value in each column of the imported file to match up with the last value in the previous file. This 'offset' would be applied to every value in the column. This same proceedure needs to be done with the next imported file and so on. I will admit I am not very proficient in script writing so any help would be greatly appreciated.

sammi.song

China
46 Posts
Posted - 02/05/2004 :  02:29:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi ringman7677,

I am not sure if I have understanded your meaning.
I suppose you just want to Append some ASCII data files to same worksheet as rows.
There is a script syntax for it: open -ar filename. Note: If there are spaces in fileName, enclose fileName in quotation marks " ".
For instance:
open -w Disk:\...\Group.dat; //open a given file Group.dat into the active worksheet.
open -ar Disk:\...\test4.dat; //Append test4.dat as new rows to this worksheet.
open -ar ...; //Append more data files.
...
And you can use "Import Multiple ASCII" button to do same job by selecting "New Rows" from Import each file as drop-down list in Import Multiple ASCII Dialog.
Hope they are useful.

Thanks,
Sammi

Edited by - sammi.song on 02/05/2004 02:40:41 AM
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