Drew Wutka
DWUTKA at Marlow.com
Wed Nov 28 14:14:13 CST 2007
A relatively simple way would be to open it with a browser, and just read the text of it: brwWebBrowser.Document.Body.innertext where bwWebBrowser would be an instance of IE. Drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Erwin Craps - IT Helps Sent: Wednesday, November 28, 2007 1:41 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] HTML code stripper I already have the process automated, but I see that HTML code get's into my database. Things like <DIV> <b> color etc. Some stuff I already replace/remove like <br> I just want plain simple text in this case. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence Sent: Wednesday, November 28, 2007 4:39 PM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] HTML code stripper Hi Erwin: I have always just opened a page in the browser and simply cut and pasted from there. Do you want an automated process? Jim --------- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.