In a formula-type column, the HTML_TO_TEXT() function converts HTML text into readable text for your collaborators.
-
Function name:
HTML_TO_TEXT()
Syntax
HTML_TO_TEXT(html_column)
Calling function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotation marks.
- do not use quotation marks for numbers.
Parameters
| Parameter | Description |
|---|---|
html_column |
The column containing the HTML value to convert. |
Example
HTML_TO_TEXT($HTML)
For a field containing <p>Hello world!</p>, the column returns Hello world!.
Return Type
The function returns a text string.
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business Use Case
HTML_TO_TEXT() cleans content imported in HTML format (email, product description, rich note) to display it clearly to your teams or reuse it in another field.
Best Practice
Use HTML_TO_TEXT() before performing a comparison or text search to avoid interference from HTML tags.