Stripping HTML Tags out of a Text record

T

Tom Olsen

All,

I have to strip away all HTML tags that will appear embedded in each
record.
Basically, I have to write something that would delete anything between <
and > including the sign. So all the <bold> and <Body> and the rest of the
tags have to be deleted,
Access 2003.

Thanks in advance..

Tom
 
S

Stephen Lebans

I answered your post int he original thread yesterday.
From: Stephen Lebans
([email protected])
Subject: Re: I have to strip HTML tags out of a line of text


View this article only
Newsgroups: microsoft.public.access.modulesdaovba
Date: 2004-11-02 16:22:06 PST


While there is probably code out ther in VB land to act as an HTML to
Text parser there may be a couple of simpler solutions.

1) Embedd the MS Internet Explorer ActiveX control on a hidden form.
Copy your HTML string to the control then read the control's text
property. To get you started see:
http://www.lebans.com/htmleditor.htm

or

2) Copy the HTML text to the ClipBoard. Then ask the Clipboard for plain
text. You will have to search for VB API clipboard routines as Access
does not expose a ClipBoard object.




--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I collect a list of tags from a document and build a list ofthem for filling a ComboBox from 0
Stripping Text from a table 1
Stripping Charcter's from a record 1
A Look Into The Good and Bad Points of XML 0
Stripping HTML tags from excel 3
Outlook 2003 - pasting html into appointment shows tags 0
I have to strip HTML tags out of a line of text 1
Font 2

Top