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 version 

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