View Single Post
  #4   Report Post  
Old 11-03-2003, 07:22 PM
Rob Halgren
 
Posts: n/a
Default tracking Magazine articles



I would scan the annual volume index (usually published in the
December issue) with Optical Character Recognition software, so that
you'd have all the indexes in text format on your computer. Then edit
them (with wordpad or notepad), so that each article (record) is on a
separate line, and each item (field) relating to the article (date,
title, page number,...) is separated by a comma. Then import the
comma-delimited database that you have just created to Excel. Once in
Excel, the data should be searchable.



I would actually write a PERL script to do the text editing... But
that is just geeky. Doesn't Orchids have an online table of contents?
If I recall, orchidweb.org has the contents of several years worth of
Orchids online. Not all of the text, but at least the table of
contents. Might be easier to grab some of that.

Rob

--
Rob's Rules: http://www.msu.edu/~halgren
1) There is always room for one more orchid
2) There is always room for two more orchids
2a. See rule 1
3) When one has insufficient credit to purchase
more orchids, obtain more credit