Convert rich text to plain text

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Jose said:
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
Click to expand...

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.
 
Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,
jcp
 
Jose said:
Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,
Click to expand...

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.
 
Fantastic, I did a small text and works perfectly.
thanks a lot
jcp

Rick Brandt said:
Jose said:
Thanks Rick
This is a good new, unfortunately, I couldn't find the function.
If you find, please let me know.
Regards,
Click to expand...

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.
Click to expand...
 
Back
Top