Menu
Amazon QuickSight
User Guide

trim Function

trim removes both preceding and following whitespace from a string.

Syntax

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

Copy
trim(' Seattle Store#14 ')

The following values are returned:

Copy
Seattle Store#14