• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Perl or Applescript w/ Excel
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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.

  • Follow-Ups:
    • Re: Perl or Applescript w/ Excel
      • From: Christopher Nebel <email@hidden>
References: 
 >Re: Perl or Applescript w/ Excel (From: Christopher Nebel <email@hidden>)

  • Prev by Date: Making a calendar in QuarXpress
  • Next by Date: Creative spelling
  • Previous by thread: Re: Perl or Applescript w/ Excel
  • Next by thread: Re: Perl or Applescript w/ Excel
  • Index(es):
    • Date
    • Thread