Home > Reference > Functions reference > Text functions > Trim
Trim Purpose 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. 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