Andy Lacey
andy at minstersystems.co.uk
Wed Nov 28 05:27:25 CST 2007
Hi Erwin Sorry, I'm not replying because I have one but it's a nice idea. Iwonder though if stripping is enough. Wouldn't you want to change <br> to vbCrLf, and to a space? And I'm no HTML expert so there may be others that need conversion rather than removal. -- Andy Lacey http://www.minstersystems.co.uk --------- Original Message -------- From: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com> To: "accessd at databaseadvisors.com" <accessd at databaseadvisors.com> Subject: [AccessD] HTML code stripper Date: 28/11/07 11:54 I was wondering if someone has a VBA based "HTML code stripper" to share with me? The target is to strip all HTML code from a block of text obtained from a downloaded HTML page with a plain simple text as a result that can be stored in a database. thx Erwin Craps Zaakvoerder Internetwinkel op http://shop.ithelps.eu http://www.linkedin.com/in/erwincraps <http://www.linkedin.com/in/erwincraps> www.ithelps.be/onsgezin <http://www.ithelps.be/onsgezin> bezoek ook eens de website van mijn zus www.friedacraps.be <http://www.friedacraps.be/> This E-mail is confidential, may be legally privileged, and is for the intended recipient only. Access, disclosure, copying, distribution, or reliance on any of it by anyone else is prohibited and may be a criminal offence. Please delete if obtained in error and E-mail confirmation to the sender. IT Helps - I.T. Help Center * Box Office Belgium & Luxembourg www.ithelps.eu <http://www.ithelps.be/> * www.boxoffice.be <http://www.boxoffice.be/> IT Helps bvba * Mercatorpad 3 * 3000 Leuven IT Helps * Phone: +32 16 296 404 * Fax: +32 16 296 405 E-mail: Info at ithelps.eu <mailto:Info at ithelps.be> Box Office * Fax: +32 16 296 406 * Box Office E-mail: Staff at boxoffice.be <mailto:figures at boxoffice.be> -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com ________________________________________________ Message sent using UebiMiau 2.7.2