Read the files with cffile, then search for a single quote in the
string, use the Mid() function to start slicing it up. If you can be sure
that 'Failed to deliver' will always exist you can look for that too. If
you want to get more advanced you could create a tickler file containing the
common phrases to search for that could be used to determine the position of
the address.
Eric
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Colin Wilson
Sent: Tuesday, December 07, 2004 1:35 PM
To: [EMAIL PROTECTED]
Subject: find email addresses in message text
I'm working on a cleanup bounced emails system for my newsletter. The
majority of bounced emails are coming back with this information (results
from a cfpop query)
Mon, 01 Mar 2004 13:34:15 -0800 - [EMAIL PROTECTED] (11)
Failed to deliver to '[EMAIL PROTECTED]' SMTP module(domain
hotmail.com) reports: host mx2.hotmail.com says: 550 Requested action not
taken: mailbox unavailable
What I want to figure out is how I can either:
1. read the email address between the quotes or
2. have the system read for all email addresses in the bounced email and
then query the database for matching email addresses and remove the bounced
subscriber.
I can get to this point where the system will find the cfpop emails that
match the bounce rule above... but can't find info how to read the string of
the email address.
Thanks for any help in advance
Colin Wilson
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
-----------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this e-mail and
attached document(s) may contain confidential information that is intended
only for the addressee(s). If you are not the intended recipient, you are
hereby advised that any disclosure, copying, distribution or the taking of
any action in reliance upon the information is prohibited. If you have
received this e-mail in error, please immediately notify the sender and
delete it from your system.
----------------------------------------------------------
To post, send email to [EMAIL PROTECTED]
To unsubscribe:
http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe:
http://www.dfwcfug.org/form_MemberRegistration.cfm
