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