473,739 Members | 2,531 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

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
3 8688
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
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***@TRASHasp faq.com> wrote in message
news:ef******** ******@TK2MSFTN GP09.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
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.HTMLEnco de() 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***@TRASHasp faq.com> wrote in message
news:ef******** ******@TK2MSFTN GP09.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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
22767
by: intl04 | last post by:
I have a memo field that is included in some Access reports I created. Is there some way for the memo field to display nicely formatted text, with line breaks between paragraphs? Or is it necessary to export the report? I tried exporting a report by using the .rtf rich-text format (the plain-text format was the only other word-processing option listed when exporting). I then opened the .rtf file in Word. However, it looks like some...
2
5232
by: Bob Dydd | last post by:
Hi Everybody I have a Listbox that has a Memo field attached to it's 2nd column which on double click copies the memo field to another Memo Field. Forms!! = ListClassification.Column(1) My problem is that the receiving Memo Field Truncates at 255 characters
3
3032
by: John | last post by:
I have a field, data type Memo, in a job details table. I have a text box on a report which I need to print the contents of this field. My problem is that the text box will only display 255 characters. How can I get the report to print this field completely. Thanks for any help out there. John.
1
6661
by: ProDevel | last post by:
Hi, I'm desperately trying to figure out how to take rich-formatted text from a rich text box and store it in a memo field (or any other type of field!) in an Access database. Can anyone help?? Cheers :) -- Regards, Ben Foster, ProDevel.
1
1995
by: Jako | last post by:
Hi guys... Well once again I'm in a dilemma. Currently I have a RTF2 object in Access that is linked to a memo field in a table, the reason for this is so that I can have bullets and numbers in the field. The problem is however that the memo field has pritty much all the ActiveX coding in it to make the RTF2 field appear the way we assigned it. Now the main idea was to reference the content of the RTF2 field the way it appears in the...
2
3866
by: alexsg | last post by:
I'm setting up a resolutions database where each resolution will be copied from Word documents and pasted into a memo field. The resolution will be in the form: Resolution title <cr> Project no <cr> Date <cr> Meeting Type <cr> Resolution (up to several paragraphs separated by carriage returns etc).
7
8847
by: ARC | last post by:
This is taken from the "What's New in Access 2007" page. However, I've looked through all the properties of a text field memo box, and cannot find the append only option. Does anyone know how to use this feature? ------------------ "Memo fields are useful for storing large amounts of information. With Office Access 2007, you can set the Append Only property to retain a history of all changes to a Memo field. You can then view a history...
4
4343
by: Charles | last post by:
Hello, I'm trying to find a good program to use for editing memo fields in Access 2003. I'd love to use Notepad or Wordpad, but the only option I'm really finding is a program called Total Access Memo. All I'm looking to do is have a field for notes, and be able to add/edit the text - and be able to use the return key to add more lines, etc.without jumping to the next record. Can Access do this natively? TIA,
7
6948
by: anthony | last post by:
Is there any way that individual words or phrases can be formatted within a memo field? Obviously, the whole field can have formatting applied but I'm interested in being able to format just part of the field. This will be in a report Many thanks
0
8969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8794
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9211
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8216
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6756
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6056
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4572
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4826
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2195
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.