Re: Unique Items in a text file
Re: Unique Items in a text file
- Subject: Re: Unique Items in a text file
- From: Peter Long <email@hidden>
- Date: Mon, 8 Apr 2002 11:40:31 -0700
Try Panorama. Been using it since late 80s and its fast and pretty
powerful. If you do much text/database stuff/publishing, it is pretty
indispensable. peter
http://www.provue.com/
Message: 3
Date: Mon, 08 Apr 2002 12:27:01 +0000
Subject: Unique Items in a text file
From: Steve Thompson <email@hidden>
To: <email@hidden>
On a daily basis I receive a text file that contains a large number of tab
delimited records. In each record, field 8 contains a product code.
I have written a script that loops through each line of data, looks at field
8, compares it with a list of product codes and, if the product code isn't
in the list, it adds it.
The idea being that at the end of the file, I have a list of unique product
codes from that data file - about 25 items.
If I had access to an SQL database, I could just import the data into a
table and do a "SELECT ALL UNIQUE product_code FROM import" which would take
a fraction of a second and have the same result as my script.
Does anyone know of a better way to achieve this list of unique values
either by script or using an OSAX or external application? As the number of
records increases in the text file, the script takes longer and longer.
Thanks in advance,
Steve
--
Peter Long (email@hidden)
Lost Moose Publishing
http://www.yukonweb.com/business/lost_moose/
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
K-L Services
http://www.yukonweb.com/business/lost_moose/books/k-l/intro.html
58 Kluane Crescent
Whitehorse, Yukon, Y1A 3G7, Canada
867-668-5076,
fax:867-456-4355
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
_______________________________________________
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.