Amazon QuickSight
User Guide

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.

trim

trim removes both preceding and following white space from a string.

Syntax

trim(expression)

Arguments

expression

The expression must be a string. It can be the name of a field that uses the string data type, a literal value like '12 Main Street', or a call to another function that outputs a string.

Return Type

String

Example

The following example removes the following spaces from a string.

trim(' Seattle Store #14 ')

For these field values, the following values are returned.

Seattle Store #14