DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

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

patteo

  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 437
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

  • Is your software in my list?
  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 6,347
Re: Parsing email into a delimited file to import into a database
« Reply #1 on: April 26, 2007, 03:58 PM »
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

  • lonesome linux warrior
  • Member
  • Joined in 2006
  • **
  • Posts: 286
    • Gathering Badge
Re: Parsing email into a delimited file to import into a database
« Reply #2 on: April 28, 2007, 12:32 PM »
try perl ;-)

Original address: https://www.donationcoder.com/forum/index.php?topic=8264.0