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