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.
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 |
Required |
Multiple |
---|---|---|---|
str |
string |
Required |
Only one |
chars |
string |
Optional |
Only one |
Examples¶
make_col trimmed_kind:trim(bundle_kind, ' ')
Removes leading and trailing spaces from bundle kinds