Removing RTF Tags on Export - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Removing RTF Tags on Export

Brian Pearson

5 years ago

I have a linked table from a SQL database that has data stored in a field (DETAILS) with RTF/HTML tags preceding the actual text. I have no trouble working with the data while in Access because I am changing the Text type to Rich Text in my queries so that I do not see the tags but when I export the table to .csv (for import into another external database), the tags remain. Can someone help me with this? Thank You!

	Richard Rost @Reply 5 years ago
Hi Brian. Welcome. There is a function called PlainText() that you can use to strip rich text tags from a string. So in your query: `X: PlainText(MyRichTextField)` And that ought to do it. I've actually got this somewhere on my list for an upcoming TechHelp video.

	Brian Pearson OP @Reply 5 years ago
Gosh - so simple and I really should have known that command. Thank so much!

	Richard Rost @Reply 5 years ago
It's not a widely known function. In fact, I've never even covered it in one of my classes... which is why it's on the TechHelp list. I'll probably just make a Fast Tip video out of it. :)

	Richard Rost @Reply 5 years ago
Rich Text

	Brian Pearson OP @Reply 4 years ago
Hi Richard - So this all works fine inside of Access, but when I Export the Query to a .csv file, the results include the RTF tags all over again. Any idea how to get around that? Thanks.

	Brian Pearson OP @Reply 4 years ago
I found a way around the problem... I used PlainText in a Make Table query which then stored it correctly and allow the Export correctly without the RTF tags but any other insight you want to offer is still welcomed.

	Richard Rost @Reply 4 years ago
That's probably the most elegant solution I'd think of.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View