Parse Values from Email Templates

[dpicella]

I've got some emails in the form of .eml files where I want to parse out some values and insert them in a MySQL DB.

For example.

TYPE: TEST
FIRST_NAME: JOHN
LAST_NAME: DOE
VISIT_CODE: 999-99-9999
AUTH: 9999999-99999
BEGIN:VTIMEZONE
TZID:(GMT-08.00) Pacific Time (US & Canada)/Tijuana
X-MICROSOFT-CDO-TZID:13
BEGIN:STANDARD
DTSTART:16010101T020000
TZOFFSETFROM:-0700
TZOFFSETTO:-0800
RRULE:FREQ=YEARLY;WKST=MO;INTERVAL=1;BYMONTH=11;BYDAY=1SU
END:STANDARD
BEGIN:DAYLIGHT
DTSTART:16010101T020000
TZOFFSETFROM:-0800
TZOFFSETTO:-0700
RRULE:FREQ=YEARLY;WKST=MO;INTERVAL=1;BYMONTH=3;BYDAY=2SU
END:DAYLIGHT
END:VTIMEZONE

What is the best way to approach this? Any suggestions. I don't need to read the email boxes, I've already got that part handled, I just need to take something like the above text (which I already have in a string) and parse the values and insert.

Perhaps Regex in PHP would be easiest.

[falko]

You can do this with the explode() function. Take a look at http://de3.php.net/manual/en/function.explode.php