Skip to main content
Question

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

  • July 7, 2023
  • 0 replies
  • 445 views

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. 

Having this field as a rich-text field prevents using it when creating a filter on the new dashboard pages. 

To test, I created a formula text field with the formula:

ToText([Name(Arabic)])

and then created a report with both fields to compare. 

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. 

This prevents me from even thinking about simply changing the field type of the existing rich-text field to plain text. 

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.   I can clean up the export outside of QB, but am wondering if I can do this via QB formulas.



------------------------------
Paul Easton
------------------------------
This topic has been closed for replies.

  • Registered
  • July 7, 2023

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
------------------------------