Re: Perl or Applescript w/ Excel
Re: Perl or Applescript w/ Excel
- Subject: Re: Perl or Applescript w/ Excel
- From: Rick Norman <email@hidden>
- Date: Wed, 14 Aug 2002 16:31:33 -0500
Chris,
You obviously work with tab-delimited files. Am I asking too much to ask how
you would go about removing duplicate records using shell tools, if it's
possible. I used AS and BBEdit together to do just that on a file I received
recently. Most of the files that we get usually go through some canned
software that has that functionality as well as other functions to meet USPS
qualifications, but on a small file there is no possible discount and I
would just like to know how it could be done. No big deal if you don't have
the time.
Thanks,
Rick Norman
>
From: Christopher Nebel <email@hidden>
>
Date: Wed, 14 Aug 2002 12:59:35 -0700
>
To: Pia Zador <email@hidden>
>
Cc: AppleScript Users <email@hidden>
>
Subject: Re: Perl or Applescript w/ Excel
>
>
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 any of the above do not apply, however (say you want to apply Excel
>
formatting to the output, or raw Unix just gives you the willies), then
>
you should use AppleScript. It's theoretically possible to control
>
Excel using perl, but it'll be really ugly.
>
>
>
--Chris Nebel
>
AppleScript Engineering
>
>
[1] There is no such word as "deliminated." The word you're looking
>
for is "delimited."
>
_______________________________________________
>
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.
_______________________________________________
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.