Convert rich text to plain

Question

I have a rich text field which can be quite long. I'd like to display truncated versions of it in some report views. I'm not aware of a function for converting rich text to plain (that is, stripping out HTML characters). When I use a simple formula like Left, the problem is that this will frequently break the long field, because closing tags won't be part of the truncated value. So the truncated version becomes something like&nbsp;
&lt;span&gt;The lazy brown fox jum
Any ideas how to strip out HTML (rich text tags)?------------------------------Jonathan Heuer------------------------------

michaeljameson · Answer

Were there any responses / solutions for this? I am having a similar issue. I have a "Rich Text" field in one application and I want to have an automation run to send the contents of that field to a "Text" field in another application; but the results are in HTML format and it is not user friendly.

------------------------------
Michael Jameson
------------------------------

austink · Answer

I see a few options that would work for this. One is to search and replace each and every tag you want removed. Depending on your exact rich text field and the contents this could be a great solution. If the contents like the tags can vary then this may not work great for you. Scroll down to the last post.

https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=c6d4e410-025d-4855-8635-bd28419978b8&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer

Another might be to use Pipelines? Look here and scroll down to "removing html tags". It may or may not do what you want but is definitely worth investigating first I think over the formula option I mentioned. https://help.quickbase.com/pipelines/transforming_data.html-------------------------------------------
Original Message:
Sent: 08-02-2021 17:31
From: Michael Jameson
Subject: Convert rich text to plain

Were there any responses / solutions for this? I am having a similar issue. I have a "Rich Text" field in one application and I want to have an automation run to send the contents of that field to a "Text" field in another application; but the results are in HTML format and it is not user friendly.

------------------------------
Michael Jameson

michaeljameson · Answer

Yes! pipelines worked. I was able to use:{{a.field_name|text}}and that stripped all the HTML tags.&nbsp; Thank you!------------------------------Michael Jameson------------------------------

Forum Discussion

Convert rich text to plain