Re: Perl or Applescript w/ Excel
Re: Perl or Applescript w/ Excel
- Subject: Re: Perl or Applescript w/ Excel
- From: Emmanuel <email@hidden>
- Date: Fri, 16 Aug 2002 01:26:59 +0200
At 9:59 PM +0200 14/8/02, Christopher Nebel wrote:
>
>
On Wednesday, August 14, 2002, at 11:44 AM, 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?
>
>
If you've got a tab-delimited [1] data file, and you want to turn it
>
into another tab-delimited file, and you're using Mac OS X, *and*
>
you're comfortable with using shell tools, you may very well be best
>
served by awk. It's not as general-purpose as perl, but it's designed
>
for processing columnar data, which is what you've got.
If you're using Mac OS X, and if you are *not* comfortable with shell
tools, the Satimage osax (a free osax) may help you much. The Satimage osax
includes many fast commands for extracting numerical data out of tables,
and for performing arithmetics on arrays of numbers.
The dictionary of the Satimage osax is on the Web:
<
http://www.satimage-software.com/en/dictosaxx.html>
Emmanuel
_______________________________________________
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.