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
Was this topic helpful? Send feedback.