HTML Data to Plain Text in Table

[Kodama76]

I have a table with 30000 records with two fields each. The first field is a record ID and the second is a memo field with text and html tags...as if you copied html code from a web page.

I NEED to get that html data (tags with text inbetween) in the memo field into just plain text in a field (not just on a form) but keep the carriage returns and line breaks and such....how can I do that?

Even if it means going out of access into another program to do I'll take what I can get. Any Ideas??

 

[amanco]

I have a table with 30000 records with two fields each. The first field is a record ID and the second is a memo field with text and html tags...as if you copied html code from a web page.

I NEED to get that html data (tags with text inbetween) in the memo field into just plain text in a field (not just on a form) but keep the carriage returns and line breaks and such....how can I do that?

Even if it means going out of access into another program to do I'll take what I can get. Any Ideas??

i was wondering if you found a solution for your problem, because i am facing the same problem now. cheers

 

[Kodo]

Don't be discouraged that this is ASP. You can EASILY adjust it for VBA.

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=155

In order to use Regular Expressions, you need to have the VBScript v5 installed and the Regular expressions for VBScript version 5 referenced in your db.

 

[amanco]

Don't be discouraged that this is ASP. You can EASILY adjust it for VBA.

http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=155

In order to use Regular Expressions, you need to have the VBScript v5 installed and the Regular expressions for VBScript version 5 referenced in your db.

thank you Kodo for your reply.

What if i want to view the html code found in the memo field? is there anyway to view it like an html file in a form or a report (without stripping the code) thanks

 

[Kodo]

do you want to view the HTML source? or do you want it displayed as a web page like in your browser?

 

[amanco]

do you want to view the HTML source? or do you want it displayed as a web page like in your browser?

like a webpage in a browser in access form/report, i tried MS web browser ActiveX, but no luck with the coding so far. appreciate your help. thanks

 

[Kodo]

Not sure about how to execute HTML like that in access. I have another idea, but I'd like to mess with your for a bit first.

 

[amanco]

Not sure about how to execute HTML like that in access. I have another idea, but I'd like to mess with your for a bit first.

i managed to view it with dHTML editor control, Me.DHTMLEdit1.DocumentHTML = txtfield

buti hope there is another way

 

[Kodo]

Well, judging from what I can tell, I'd say it's quite possible that you can't do it the way you want to do it.

My alternative..call the record using a query

use RS.SAVE to an html file and then open it in a browser.