Data Synchronisation StudioUser GuideCalculated ColumnsFunctionsTRIMOn this pageTRIM Removes the space character or other specified characters from the start or end of a string. Syntax string TRIM(string value) Example The CustomerName field has "'" at either end and you wish to remove this e.g. 'John Smith': TRIM("'","CustomerName) Will return "John Smith".