ill post is again just incase it got missed
<cfsavecontent variable="str"> <a href="mailto:[EMAIL PROTECTED]>steve</a> <a href=mailto:[EMAIL PROTECTED]>steve</a> <a href="mailto:[EMAIL PROTECTED]">steve</a> <a href=mailto:[EMAIL PROTECTED]>steve</a> <a href="mailto:[EMAIL PROTECTED]">steve</a> <a href=mailto:[EMAIL PROTECTED]>steve</a> </cfsavecontent> <cfset mail = reFindNoCase("(mailto:)([^"" >]*)", str, 0, true)> <cfif mail.len[1] GT 0> <cfloop condition="mail.len[1] NEQ 0"> <cfoutput>#MID(str, mail.pos[3], mail.len[3])#</cfoutput><br> <cfset mail = reFindNoCase("(mailto:)([^"" >]*)", str, mail.pos[1]+mail.len[3], true)> </cfloop> </cfif> -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chad Renando Sent: Friday, May 06, 2005 3:22 PM To: CFAussie Mailing List Subject: [cfaussie] RE: extracting email addresses Or you could just find everything NOT an email address and replace it with a carriage return until you get something manageable. Chad who dropped his 6-year Gateway lap top and is at present 59%, 24 hours and 342 bad sectors into running a surface scan. On 5/6/05, Palermo, Tiffany <[EMAIL PROTECTED]> wrote: > cant you do a find and replace in dreamweaver and then copy paste to word > insert carrage returns then copy paste to excell then run a macro in Access to dump the data direct in the table that the email addresses have to display in. if it has to go in a oracle database then run a querrie to drop the info in the table > > tiff > > Disclaimer: > This overrides any disclaimer or statement of confidentiality that may be > included on your message. > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Jamie > Lawrence Jenner > Sent: Thursday, 5 May 2005 1:10 AM > To: CFAussie Mailing List > Subject: [cfaussie] extracting email addresses > > hi there, > > i have just been given a html page with over 1000 email addresses and i > have been asked to insert them all into a db. I dont like typing so i > thought i could use some sort of loop and a reg ex. I have a reg ex for > validating email addresses. My thoughts are maybe to use the find > function, to find the first 'mailto:' position, then, find the position of > the end of the email address, by looking for .com, .co.uk .net etc, of > the address after the mailto, then use the remove function to remove the > before mailto string and the after .com portions, insert the email into > the db, then carry on processing the 'after' part of the string > > I have tried to do this myself, but i just cant get it to work. > > It is mashing my now hurting head > > any ideas? > > TIA > > Jamo > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
