trim¶
Description¶
trim removes leading and trailing characters from a string.
The default value for chars is ' ' (a single space character). If chars is not specified, trim removes all leading and trailing spaces.
See also ltrim, rtrim.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
trim(str, [ chars ])
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
str |
string |
no |
no |
none |
chars |
string |
yes |
no |
constant |
Examples¶
make_col trimmed_kind:trim(bundle_kind, ' ')
Removes leading and trailing spaces from bundle kinds