The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Rich Text formatting
Posted: 28 Aug 07 3:56 PM
|
V6.2.4
We have some fields (type Memo) in tables that have data saved in them from richedit fields. I have noticed that when I access the data in these fields, like in speed search or I also have a Merge function that grabs the data in these fields...anyway when it displays the data it captures the text but it also displays all of the formatting before the text? is there a reason it is doing this? it looks like this ....{\rtf1\ansi\ansicpg1252\deff0{\fonttbl{\f0\fswiss\fprq2\fcharset0 Arial;}{\f1\froman\fprq2\fcharset0 Times New Roman;}}
\viewkind4\uc1\pard\lang1033\f0\fs18
is there some setting i need to have or something i need to do before it gets saved?
Thanks |
|
|
|
Re: Rich Text formatting
Posted: 28 Aug 07 4:06 PM
|
You could:
- Bind the Text property instead of the Rich Property to the Field (of course, this means that you don't preserve the Rich Text)
- Bind (or Save) the Text property to a different Field and use that field on Speed Search and on Mail Merger |
|
|
|
Re: Rich Text formatting
Posted: 30 Aug 07 2:23 PM
|
Raul
This will work going forward but I want to go back and copy all of the text that has the RTF parameters in front of it to the new "just text" field. I am think about running a one time agent that will just go thru each record and do the copy...problem is how do i take the data in the RTF field with the RTF parameters attached to it and strip that off to get just the text so i can place that in the new text only field? any ideas would be greatly appreciated. Is there any function that would strip out that stuff?
John |
|
|
|
Re: Rich Text formatting
Posted: 31 Aug 07 8:10 AM
|
John:
I believe that you are going to need a conversion routine. What I do not know is wheter the content of the blob can be streamed out into an RTF document. If so, then you could write a script that takes each RTF blob, saves it as an RTF file, opens it on Word and then just select the text from Word and save it into the Text field (or alternatively, Save the doc as a Text file and then Read and Save that into the Text field). |
|
|
|