Forum Discussion

MichaelTamoush's avatar
MichaelTamoush
Qrew Captain
3 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
3 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
    3 years ago
    I haven't tried, but OF course! Good idea to parse it out like that.

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