HTML_TO_TEXT() : convert HTML to plain text

In a formula-type column, the HTML_TO_TEXT() function converts HTML text into readable text for your collaborators, and returns a text string.

The output type format of the result is configured in the output field options of the formula editor: see Formula column.

Syntax

HTML_TO_TEXT(html_column)

How to reference parameters in TimeTonic: $field_name for a field (link, linked-table column, number, selection, formula, text); "free text" in quotes; no quotes for numbers.

Parameters

# Parameter Description

1 html_column The column containing the HTML value to convert.

Example

Convert HTML content into readable text

"<p>Hello world!</p>" becomes "Hello world!".

HTML_TO_TEXT($HTML)

HTML_TO_TEXT result: HTML text converted into readable text

Business use case: HTML_TO_TEXT() cleans up content imported in HTML format (email, product description, rich note) to display it readably to your teams or reuse it in another field.

Best practice: use HTML_TO_TEXT() before a comparison or a text search, so that HTML tags do not get in the way.

Go further

TRIM

Remove unnecessary spaces from a text string.

Read more →

Or continue with

Formula glossary

All available operators and functions, organized by category.