Re: A Faster Script
Re: A Faster Script
- Subject: Re: A Faster Script
- From: Dirk Frank <email@hidden>
- Date: Tue, 6 Apr 2004 10:38:41 +0200
Hello,
i found this at macdevcenter
http://www.macdevcenter.com/pub/a/mac/2004/02/27/cleaning_iphoto.html
a similar problem of time consuming. i would also agree to solve that
with perl.
make a tab del. or csv text file and open that with excel.
the last time i use perl out of AS with "do shell script" more often,
because it speeds up such things. Especially text cleaning with regex.
So you could use your AS, but the "string work" and file creation could
be done in perl, after the file is created your AS can advise Excel to
open that file.
cheers,
dirk
Am 06.04.2004 um 09:54 schrieb Richard Morton:
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.
--
Consult a professionally trained computer scientist or a twelve year
old child before attempting anything difficult on your own machine.
_______________________________________________
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.