thanks everyone, but steve suggestion is more along my lines of what i was looking for
cheers again steve jamo > 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/
