Convert rich text to plain text

[Guest]

I tested using Rich text in acc2007. When I export the text to excel or word
text via adodb.recordset, it exports the RTF with code.
I'm thinking create a second column to store text unformatted. Unfortunately
I don't know how I can convert RTF to plain text (unformatted text)

Any body else can help me?

Thanks
jcp

 

[Rick Brandt]

I tested using Rich text in acc2007. When I export the text to excel
or word text via adodb.recordset, it exports the RTF with code.
I'm thinking create a second column to store text unformatted.
Unfortunately I don't know how I can convert RTF to plain text
(unformatted text)

Any body else can help me?

Thanks
jcp

You don't need to store the plain text separately. There is a function you can
use in a query that will extract the plain text from the RTF formatted field and
then you can export the query instead of the table.

Unfortunately, I don't recall the name of that function, but in previous
threads in these groups I'm sure I have seen it discussed (Lyle Fairfield I
think pointed it out). Perhaps a thorough reading of the help topics covering
the rich text subject would turn it up. It might be as obvious as PlainText(),
but that's just a guess.

 

[Guest]

Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,
jcp

 

[Rick Brandt]

Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,

Apparently it is just PlainText(). So to get the plain text of your Rich
Text Formatted field you should be able to use...

SomeAlias: PlainText([YourFieldName])

....in a query.

 

[Guest]

Fantastic, I did a small text and works perfectly.
thanks a lot
jcp

Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,

Apparently it is just PlainText(). So to get the plain text of your Rich
Text Formatted field you should be able to use...

SomeAlias: PlainText([YourFieldName])

....in a query.