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

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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?
Photo of Sam W

Sam W

  • 340 Points 250 badge 2x thumb

Posted 4 months ago

  • 0
  • 1
Photo of QBAlchemist

QBAlchemist

  • 160 Points 100 badge 2x thumb
You probably truncated a few HTML elements. Ensure you are only truncating on the Text part, not the entire formula contents. 
Photo of Sam W

Sam W

  • 340 Points 250 badge 2x thumb
Ah, I'm a fool. Thank you, yes - you were right.