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.