topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • Friday April 19, 2024, 5:00 pm
  • Proudly celebrating 15+ years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: Parsing email into a delimited file to import into a database  (Read 3324 times)

patteo

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 437
    • View Profile
    • Read more about this member.
    • Donate to Member
I subscribe to a daily wisdom type of email which I receive each day. But I find that I may not read it all the time.

One of the things I like to do is to parse the information into a delimited file which I can then import into a database.

I can then search the database by criteria for what I want later.

The email follows a specific format so that can make it easier to parse the information.

Does anyone know of a utility available that can intelligently extract the information easily ?

This of course assumes that I can configure it to follow some rules so it will know what to do to convert it into a delimited file format.

superboyac

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
    • View Profile
    • Donate to Member
Re: Parsing email into a delimited file to import into a database
« Reply #1 on: April 26, 2007, 10:58 AM »
The only program I know of that might do this is Mailbag Assistant.  I've tried this program halfheartedly a couple of times, but I had no real use for it.  But it sounds like it's exactly what you need.

gjehle

  • Member
  • Joined in 2006
  • **
  • Posts: 286
  • lonesome linux warrior
    • View Profile
    • Open Source Corner
    • Read more about this member.
    • Donate to Member
Re: Parsing email into a delimited file to import into a database
« Reply #2 on: April 28, 2007, 07:32 AM »
try perl ;-)