By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,929 Members | 1,732 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,929 IT Pros & Developers. It's quick & easy.

Content from a memo field: converting the rich text into plain text

P: n/a
Hi folks,
I have an Access 2000 db with a memo field.
Into the memo field I put text with bold attributes, URL etc etc

What I need to to is converting the rich text contained into the memo
field in plain text.
That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.

Don't know if it's clear enough.

Just to summarize:

1) memo field cointaining rich text
2) I need to transform it in plain text

Thanks in advance
Paolo
Jul 19 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
ASP doesn't know what "rich text" is. All that's stored in the database is
a big string.

Maybe some of the following could help:
http://www.aspfaq.com/2395

"Alfredo Agosti" <ja***************@hotmail.com> wrote in message
news:bk************@ID-83500.news.uni-berlin.de...
Hi folks,
I have an Access 2000 db with a memo field.
Into the memo field I put text with bold attributes, URL etc etc

What I need to to is converting the rich text contained into the memo
field in plain text.
That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.

Don't know if it's clear enough.

Just to summarize:

1) memo field cointaining rich text
2) I need to transform it in plain text

Thanks in advance
Paolo

Jul 19 '05 #2

P: n/a
Thanks but it couldn't help.
I need exactly the opposite.
I have formatted (rich text or rtf text I don't know) text and I would
convert it into plain text.

But a text field can't contain bold reference so it must exist a way to
strip the formatting codes from a memo field...

James

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:ef**************@TK2MSFTNGP09.phx.gbl...
ASP doesn't know what "rich text" is. All that's stored in the database is a big string.

Maybe some of the following could help:
http://www.aspfaq.com/2395

"Alfredo Agosti" <ja***************@hotmail.com> wrote in message
news:bk************@ID-83500.news.uni-berlin.de...
Hi folks,
I have an Access 2000 db with a memo field.
Into the memo field I put text with bold attributes, URL etc etc

What I need to to is converting the rich text contained into the memo field in plain text.
That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.
Don't know if it's clear enough.

Just to summarize:

1) memo field cointaining rich text
2) I need to transform it in plain text

Thanks in advance
Paolo


Jul 19 '05 #3

P: n/a
You could either (a) strip the references before storing them in the first
place; (b) write a script that will remove the references from the database;
or (c) use server.HTMLEncode() if you mean HTML and not rtf.


"Alfredo Agosti" <ja***************@hotmail.com> wrote in message
news:bk************@ID-83500.news.uni-berlin.de...
Thanks but it couldn't help.
I need exactly the opposite.
I have formatted (rich text or rtf text I don't know) text and I would
convert it into plain text.

But a text field can't contain bold reference so it must exist a way to
strip the formatting codes from a memo field...

James

"Aaron Bertrand - MVP" <aa***@TRASHaspfaq.com> wrote in message
news:ef**************@TK2MSFTNGP09.phx.gbl...
ASP doesn't know what "rich text" is. All that's stored in the

database is
a big string.

Maybe some of the following could help:
http://www.aspfaq.com/2395

"Alfredo Agosti" <ja***************@hotmail.com> wrote in message
news:bk************@ID-83500.news.uni-berlin.de...
Hi folks,
I have an Access 2000 db with a memo field.
Into the memo field I put text with bold attributes, URL etc etc

What I need to to is converting the rich text contained into the memo field in plain text.
That's because I truncate the string text but if, when I truncate it
there's a rich tag the code following the truncated string is corrupted.
Don't know if it's clear enough.

Just to summarize:

1) memo field cointaining rich text
2) I need to transform it in plain text

Thanks in advance
Paolo



Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.