[AccessD] HTML code stripper

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.





More information about the AccessD mailing list