Important: We've redesigned the Amazon QuickSight analysis workspace. You might encounter screenshots or procedural text that doesn't reflect the new look in the QuickSight console. We're in the process of updating screenshots and procedural text.
To find a feature or item, use the Quick search bar.
For more information on QuickSight's new look, see Introducing new analysis experience on Amazon QuickSight
trim
trim
removes both preceding and following blank 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