Reference > Functions reference > Text functions > Trim
 

Trim

Returns text stripped of all leading and trailing spaces.

Format 

Trim ( text )

Parameters 

text - any text expression or text field

Data type returned 

text

Originated in 

FileMaker Pro 6.0 or earlier

Description 

Use this function to remove unneeded spaces when you convert files from other programs or systems that require a fixed number of characters per field, or to remove spaces accidentally typed during data entry.

Example 1 

Trim ( " Tom " ) returns Tom.

Example 2 

Trim ( Middle ( "00230013 William 1234" ; 9 ; 9 ) ) returns William.

Related topics 

Functions reference (category list)

Functions reference (alphabetical list)

About formulas

About functions

Defining calculation fields

Using operators in formulas