Trim function

Contents > Functions reference (alphabetical list) > Text functions > Trim function

Trim function

Format


Trim(text)

Parameter

text - any text expression or text field

Data type returned

text

Description

Returns text stripped of all leading and trailing spaces.

Tip Use the Trim 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.

Examples

Trim(" Tom ") returns Tom.

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

Contents > Functions reference (alphabetical list) > Text functions > Trim function