Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago

How can extract just the text from a rich text field?

I have a rich text field that looks like below (a snip from it) If( [Rejected/Cancelled]=true, "<div style=\"font-weight:bold; font-size:14px;padding-left: 5px;padding-right: 5px; padding-top: 10...
Formulas and functions
GauravSharma1's avatar
GauravSharma1
Qrew Member
4 years ago

Hi Mike,

Hope you are doing well.

You can use the below formula for the same. Just replace my [Your Rich Text Field] field with your actual rich text field.

Left(Part([Your Rich Text Field],2,">"),"<")

The above formula will extract only text. Try this out and let me know if this works for you in this case.

Thanks,



------------------------------
Gaurav Sharma
Business Application Architect
Westhaven Power, Inc
+91-8826743679
------------------------------
MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
4 years ago
I haven't tried, but OF course! Good idea to parse it out like that.

------------------------------
Mike Tamoush
------------------------------