trim Search Operator
trim operator eliminates leading and trailing spaces from a string field.
trim(<field>) as <field>
trim(" <string expression> ") as <field>
Take the string value " Hello World ". To remove the leading and trailing spaces you'd do the following:
| trim(" Hello World ") as greeting
This would return a field named greeting with a new value of "Hello World".