Copying rich-text field data to plain-text field without the HTML code

Question

We have a table that includes the fields "Name (ASCII/Latin)" and "Name (Arabic)".
The "Name (Arabic)" field was created as a rich-text field. Which, IIRC, was because, when the app was created, QuickBase didn't support UNICODE in plain-text fields.&nbsp;
Having this field as a rich-text field prevents using it when creating a filter on the new dashboard pages.&nbsp;
To test, I created a formula text field with the formula:
ToText([Name(Arabic)])
and then created a report with both fields to compare.&nbsp;
The Arabic text now displays in the plain-text field, but ,any of the transformed-to-text names in the plain-text version have HTML tags.&nbsp;
This prevents me from even thinking about simply changing the field type of the existing rich-text field to plain text.&nbsp;
Does anyone have any handy formulas that will strip out all HTML when copying from a rich-text to plain text field?
The HTML is also there when I export to CSV.&nbsp; &nbsp;I can clean up the export outside of QB, but am wondering if I can do this via QB formulas.

------------------------------Paul Easton------------------------------

gary1 · Answer

What HTML elements are appearing? If they're consistent, you can probably nip them using SearchAndReplace. Otherwise I'd need to see some examples to understand the issue entirely.

------------------------------
gary
------------------------------

markshnier__you · Answer

I seem to recall that there is some Jinja syntax where a pipeline can stip out all HTML.

https://community.quickbase.com/discussion/outlook-pipeline-email-body#bmc03a24e8-ebf0-40fc-aea5-0184cf724003The striptags filter should do what you want:&nbsp; {{ email.body | striptags }}------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

pauleaston · Answer

If no easy way to do with QB formulas, I'll just download to CSV and run search and replace using RegEx to remove < and > and anything in between those two characters.

------------------------------
Paul Easton
------------------------------

pauleaston · Answer

Thank you, I really need to take some time and get familiar with using Jinja in pipelines. For now, I think it will be quicker for me to export the text and edit outside of QuickBase. Then import the clean text. This is a one-time operation.

------------------------------
Paul Easton
------------------------------

Forum Discussion

Copying rich-text field data to plain-text field without the HTML code

Related Content

Rich-text formula button on dashboard

Rich Text Button with rounded edge

Parse Through Rich Text Field

Rich text field html whitelist

Formula Rich Text Button: Report Link