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
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.