trim

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

     

Was this helpful?
How can we improve it?