| T O P I C R E V I E W |
| ringman7677 |
Posted - 01/15/2004 : 3:33:59 PM
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. |
| 1 L A T E S T R E P L I E S (Newest First) |
| sammi.song |
Posted - 02/05/2004 : 02:29:44 AM
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 |
|
|
