Convert rich text field contents to standard text

Many times I have a challenge where I need to convert notes rich text field content into standard text (for instance, displaying the contents of a rich text field in a view!). Here is a quick solution to this challenge.

First, Create a rich text field on your form. You can call this what ever you like (just remember it!). I will call mine MyRichText1. Now create a plain text field on the same form to hold the converted contents. I will call mine MyPlainText1. Be sure to make this field type to "Text" and make it "Computed". You can hide this field from the edit mode or hide it totally if you are just using it to convert. In the programmers pane for the plain text field (MyPlainText1), enter the following formula: @Abstract([TextOnly];512;" ";"MyRichText1"). I know you are wondering what the 512 number represents. It is the maximum size (in bytes) of the text you want to bring in. This formula takes the content stored in the rich text field (MyRichText1), converts the text into plain text and places it in the field MyPlainText1. Pictures and other embedded media are ignored. Now you can use this new plain text content in views and in agents to send plain text e-mail and do all sorts of cool things. Good Luck!!!

 @Abstract([TextOnly];512;" ";"MyRichText1")

This was first published in July 2002

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.