TRIM - Removing Leading and Trailing Spaces from the Text- FineBI Help Document

Last update：July 25, 2023

Overview

Grammar	TRIM(text)	Returns the text with all leading and trailing spaces removed.
Parameter 1	text	Text from which you want to remove spaces

Notes

The function supports only one text parameter.

Example

The TRIM function can remove all extra spaces at the beginning and end of the text.

For example, to remove leading and trailing spaces from the text " software advice ", you can add a calculation indicator with the formula TRIM(" software advice "), as shown in the following figure.

Drag this indicator into the analysis area, as shown in the following figure.

Another example:

Formula	Result	Notes
TRIM(" Monthly Report")	Monthly Report	-

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

TRIM - Removing Leading and Trailing Spaces from the Text

Overview

Notes

Example

附件列表