On 16 May 97, Carl Forsythe wrote:

> I have two lists that are hovering somewhere between 30-60K subscribers
> (each) and I need to (for mysterious reasons not my own, can you
> say...management?)
> compare the two lists and find out the total number of unique users.
>
> I know one way which is to just get the lists on my unix box then have a
> script
> chug through them looking for dupes, but is there an easier way?

Most word processors or databases can import a text file, then you'll have a
searchable/editable database.  The database type of solution is easier, or you
can even go into a spreadsheet and then export into a WP or DB.  I maintain a
information database for a much smaller list by doing a rev listname by name
noh and then saving it as a text file, editing out the headers, and sending it
into the database.  Sometimes you'll need the additional step of inserting
commas, but there is probably a way around it.  Any good programmer should be
able to stream it into something useable.  Sounds like a fun challenge! (did I
say that?)

Liz Marr

~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~
          Liz & the Terv Herd
  Somewhere on the beautiful Oregon coast
              Spiritbrook
 Working Labradors, Siberians, Tervuren
            John 4:14
~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~@~~
mailto:[log in to unmask]
http://www.cc-ent.com/Spiritbrook