# 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.

string

## Domain¶

This is a scalar function (calculates a single output value for a single input row.)

## 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