Removes all whitespace from the beginning and end of string and removes any double spacing between words in string.
string can be any of the following:
- A String constant, such as "GDN".
- A Search Ads 360 variable that is a String, such as
Engine_status, and so on.
- An expression or formula column that returns a String.
[trim(" a ")]returns "a".
[trim(" double spaces ")]returns "double spaces".