Skip to main content
Removes unwanted characters from the start and/or end of a value. By default it strips away surrounding whitespace, which is the usual job: cleaning up stray spaces, tabs, and line breaks that slip into imported data. You can also remove specific characters of your choosing, such as trimming leading zeros or a trailing slash. Only the outer edges are touched; characters in the middle of the value are left alone.

​
Fields

​
Sample data

FieldValue
Side to trimboth
Characters to trim(empty, so whitespace)
Input: 
{ "name": "   Wool scarf   " }
Output: 
{ "name": "Wool scarf" }