Re: A Faster Script
Re: A Faster Script
- Subject: Re: A Faster Script
- From: Richard Morton <email@hidden>
- Date: Tue, 6 Apr 2004 17:54:35 +1000
On 6 Apr 2004, at 3:33 PM, Chip Fillingane wrote:
...and one of the things we
have to do is copy and past thousands of points into Microsoft Excel.
It's really very boring. So I tried to automate it with applescript...
...I'm certain there is a faster way to do this,
but I don't see it.
The data points are spread across around several tab delimited files.
Each files goes into two separate columns, and the columns are labeled
with a number and either an 'x' or a 'y'...
I may not be understanding your problem but I would probably tackle
this by assembling the data in one text file as tab/return delimited,
using AS, then just open the file with Excel.
...It take approximately 5 minutes to move 6000 data points by this
method. Considering each file has between 3000-6000 data points, and
there generally 70 to 80 files those five minutes add up to several
hours very quickly.
It's still a big job for AS & would take a while but nothing like this.
From what I know of perl - friends who use it - that would be a better
tool again.
Cheers,
Tex Chainsaw
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.