Skip to content

RICH_TEXT_TO_PLAIN_TEXT

Info

New in Atfinity 16.0.14

Description

RICH_TEXT_TO_PLAIN_TEXT returns the text of a rich text information without its formatting. Reading one directly gives you the stored structure, so use this operator wherever the value goes to an integration, a document or anything else that expects text.

Formatting such as bold, italic and lists is dropped, while the words and the line breaks are kept. A value that is already plain text is returned unchanged.

Syntax

RICH_TEXT_TO_PLAIN_TEXT(value)

Returns: a string, or unknown if the value is unknown.

Example

source_of_wealth_description holds:

Salary from 2019

  • Bonus
  • Dividends
RICH_TEXT_TO_PLAIN_TEXT(p.source_of_wealth_description)

This returns the text without the bold and the bullets:

Salary from 2019
Bonus
Dividends