Formula Engine Reference Guide
 

 

Back to Class Index

 

TRIM(S)

Description
Returns the string formed by removing leading, trailing and consecutive embedded spaces from string S.
 
Parameters
S
A string value
 
Examples
TRIM(" Alpha Beta Gamma ") = "Alpha Beta Gamma"
 
TRIM(R5) = "There's no place like home."
where R5 = "There's no place like home."