Removes duplicate spaces, and the spaces from the start and end of a text string.
Syntax
TRIM (“Text”)
Data Types of the Arguments
String
Data Type of the Result
String
Example
The text string has unneeded spaces at the beginning and the end, and multiple extra spaces between each word.
Use TRIM to remove these unneeded spaces.
Expression
TRIM (“ Q4 2017 Earnings Report ”)
Result
Q4 2017 Earnings Report