[AccessD] HTML code stripper

Erwin Craps - IT Helps Erwin.Craps at ithelps.eu
Wed Nov 28 13:40:30 CST 2007


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





More information about the AccessD mailing list