Removes all whitespace from the beginning and end of string and removes any double spacing between words in string.
Syntax
trim(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
Keyword,Campaign,Engine_status, and so on. - An expression or formula column that returns a String.
Examples
[trim(" a ")]returns "a".[trim(" double spaces ")]returns "double spaces".