Forum Discussion

SamW's avatar
SamW
Qrew Cadet
6 years ago

How to Keep HTML after Using Left Function to Produce Excerpt?

I use the Left function in a Rich Text Formula field to show the first 200 characters of a regular Rich Text field. However, in a report, this appears to strip it of its HTML function, showing the source code instead.

e.g. Hello become <a href="google.com">Hello</a>

Is there a way for me to avoid this, and preserve the HTML functionality?
  • You probably truncated a few HTML elements. Ensure you are only truncating on the Text part, not the entire formula contents. 
  • SamW's avatar
    SamW
    Qrew Cadet
    Ah, I'm a fool. Thank you, yes - you were right.