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/
