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/
