TRIM - Removing Leading and Trailing Spaces from Text- FineDataLink Help Document

Last update: May 30, 2025

Overview

Syntax	TRIM(Text)	Removes leading and trailing spaces from Text.
Parameter	Text	The text from which you want spaces removed
Return Value Type	Text

Example

Formula	Result
TRIM(" Monthly Report")	Monthly Report

The TRIM() function can be used to remove any extra spaces at the beginning and end of text.

For example, to remove leading and trailing spaces from " software advice ", add a New Calculation Column operator and input the formula TRIM(" software advice "), as shown in the following figure.

Click Data Preview. You can view the field with spaces removed in the new column, as shown in the following figure.

Previous：REGEXP - Determining If a String Matches a Regular Expression

Next：CHAR - Returning the Character Specified by a Number

Helpful
Not helpful
Only read

中文（简体）

English

TRIM - Removing Leading and Trailing Spaces from Text

Overview

Example

附件列表