Analytics SAQL Reference
jNewer Version Available
trim()
Removes the specified substring from the beginning and the end of a
string.
Syntax
trim(string,substr)
Usage
This function removes substr from the
beginning and end of string, then returns the result. To remove
leading and trailing spaces, do not specify a value for substr.
Example
1–- the resulting string in both cases is 'MyString';
2q = foreach q generate trim("abcMyStringabc","abc") as 'Trimmed String';
3q = foreach q generate trim(" MyString ") as 'Trimmed String';