You are here: Features > Cell Functions > Text Functions > TRIMRTF function

TRIMRTF Function

The TRIMRTF function trims RTF formatting from a string. Use it to trim formatting from Issues Description fields in browses and scripting.

RTF code looks like the following:

{\rtf1\ansi\ansicpg1252\deff0\deflang

Syntax

TRIMRTF(expression)

Example

TRIMRTF("{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 MS Shell Dlg;}}\viewkind4\uc1\pard\f0\fs17 Stripping RTF Formatting Information\par }")

Displays the string Stripping RTF Formatting Information.

Notes

  • When using the TRIMRTF function, ensure that the size of the display cell is set to the correct width to display the trimmed result properly.

Related Topics