Importing/parsing data from email text

[MrJeff]

Brief background:

Webhost backed up server - and after upgrading OS, data from mysql was not restored... 20,000+ records lost. UGH! Says anything that can be restored is...

After moving to a new host ... realized I had received emails from each form submission. Was able to dump them to text files. Using a small group, imported each text file into a seperate record. Entire email is in one field. (To, From, Subject, Date & Body)

Have been playing for several days trying to parse the data into individual emails so I can get the newsletters back up & runnning. Played with Middle, Position, etc... but having trouble figuring out how to capture everything from the field name to the end of the line...

Have FM7/8 osx 10.4 - and not opposed to using AS/automator, etc.

Thanks in advance!

-Jeff

Here is a sample record:

****************************

Someone just subscribed to your autoresponder called "25secrets".

Their e-mail address is [email protected]

Here are the contents of the subscription form:

arpcustom_bdday - 31

arpcustom_bdmonth - 08

arpcustom_bdyear - 1998

arpcustom_childfirst - Daniel

arpcustom_childlast - Smith

capitals - 1

email - [email protected]

extra_ar -

first_name - Mommy

format - H

id - 2

last_name - Smith

title - Ms.

tracking_tag - enter

** END OF FORM CONTENTS **

[comment]

Here's an example that extracts the last name parameter:

Let ( [

start = Position ( email ; "last_name" ; 1 ; 1 ) + 12 ;

end = Position ( email ; ¶ ; start ; 1 )

] ;

Middle ( email ; start ; end - start )

)

Or, in a more general form:

Let ( [

prefix = "last_name - " ;

start = Position ( email ; prefix ; 1 ; 1 ) + Length ( prefix ) ;

end = Position ( email ; ¶ ; start ; 1 )

] ;

Middle ( email ; start ; end - start )

)

Here you can change the prefix, and it will extract that parameter.

[MrJeff]

THANK YOU, THANK YOU, THANK YOU!

That did the trick!

How can I thank you?!?

[comment]

You already did - three times...