Subj : Re: Complicated email parse or text extraction and database insertion
To   : comp.programming
From : Sc0rpi0
Date : Tue Aug 16 2005 08:52 am

code_worthy@bellsouth.net:

> I am trying to strip some data out of numerous emails and place it in
> my database.  I know that this seems as if it has been done before.
> But, this is a little different.  First, the numerous emails all have a
> set of data that needs to be extracted and inserted into the database.
> Some of the data in the email is id, name, address, city, state, zip,
> company, etc.  The catch is that the date is formated and presented
> differently in each email.  Take into consideration the following email
> examples:

regex.h (or just any regular expr. library) ? there only may be
difficulties with one space separators, in example:

City State ZIP
Salt Lake City Utah 12345

Now hard to say if city is Salt and state is Lake City Utah ;),
but you can just do small databases of known fields (i.e state list)
and value has to be one of them. I hope you don't prepare some spam
database ;) ?


-- 
Sc0rpi0
I hated going to weddings.
All the grandmas would poke me saying "You're next".
They stopped that when I started doing it to them at funerals.

.