I'm working on a project to index a bunch of sermons for my church. I'm hoping I might be able to get some advice from some readers with experience on databases and/or scripting.
Particularly, the problem is this: There are full-text transcripts of roughly several hundred sermons. We would like to compile an index of Scripture references as a study aid. That is, we'd like to be able to look up which sermons mentioned particular Scriptures. I'd like to have a script or program I can run on a directory full of sermons to compile an index of Scripture references.
I'm sure this, or something similar, is a solved problem, as I often see indexes of Scriptures at the end of books (i.e. theology books), and people probably don't compile those indexes by hand. I have a rough idea how I might go about this with a Perl script, but before I go and spend a day or so trying to muddle through and make it work, I thought I should ask: Has anyone done this before (or something like it), and if so, can you give me any pointers?
No need to respond extensively in the comments. You can reach me by e-mail at abednego.azariah at gmail dot com.
And, for those still with me, I'll point out that I put this in the "Fun" category, as, strangely enough, I think it will be fun getting this to work.