Convert rich text to plain

  • 1.  Convert rich text to plain

    Posted 01-31-2020 14:45
    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 
    <span>The lazy brown fox jum
    Any ideas how to strip out HTML (rich text tags)?

    Jonathan Heuer