Re: Perl or Applescript w/ Excel
Re: Perl or Applescript w/ Excel
- Subject: Re: Perl or Applescript w/ Excel
- From: Geoff Canyon <email@hidden>
- Date: Fri, 16 Aug 2002 01:02:04 -0700
At 11:44 AM -0700 8/14/02, Pia Zador wrote:
>
I am about to write a script that takes a bunch of tab-deliminated text
>
files, extracts certain numeric data, performs simple arithmetic on the
>
extracted data, and outputs the new data to a workbook in Excel.
>
>
Does anyone have suggestions on whether to use Perl scripts or simply
>
Applescript? Is one easier to use when dealing with tab deliminated data
>
and/or Excel workbooks?
Just a thought from left field. You could do this very easily in Revolution. The advantages over either Perl or AppleScript are:
1. Built-in user interface tools -- you might not need them, but sometimes even just a progress bar is nice.
2. Regular expressions -- as someone said talking about Perl, they're great.
3. Chunk expressions -- can come in _very_ handy.
4. URL-based file access -- read the contents of a file with a one-line command.
5. Faster than either Perl or AppleScript.
Note that Revolution would be free for this purpose. You'd need to live within the script-length limits, but based on your description, that shouldn't be too hard.
http://www.runrev.com
--
regards,
Geoff Canyon
email@hidden
Disclaimer: email@hidden
_______________________________________________
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.