Hey Colin, This is a good application for regular expressions.
Ray Camden has a UDF that uses regexp to return email addresses within a string as a list: http://cflib.org/udf.cfm?ID=928 Use that to get the email addresses, then loop through that list to do your other stuff. Hope this helps, Seth > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On 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 > > > ---------------------------------------------------------- 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
